hasonevalue dax | Power BI DAX Tutorial Part 1| hasonevalue example

#powerbitraining #powerbi_training #dax #powerbizone #hasonevaluedax
In this Power BI DAX Tutorial, we discuss the usage of hasonevalue dax in Power BI with an easy example. I have tried to explain 3 scenarios related to the usage of hasonevalue dax function .
This tutorial discusses the functionality of HasOneValue Dax : Its a very simple dax which returns TRUE when the context for column Name has been filtered to one distinct value only. Otherwise is FALSE.

Syntax: HASONEVALUE(ColumnName)
Parameter: It passes the name of an existing column. It cannot be an expression.

Return value : Boolean TRUE/FALSE

This HASONEVALUE function is not supported for use in DirectQuery mode when used in calculated columns or RLS.

For more explanation related to this dax tutorial in Power BI please visit :
https://powerbizone.com/hasonevalue-d...

Chapters:
0:00 Introduction to Hasonevalue dax
0:20 Example Scenario 1
4:07 Example Scenario 2
6:30 Example Scenario 3

Check out other Power BI Tutorials Videos :
1.SamePeriodLastYear with Example:    • difference between parallelperiod and...  
2.How to Calculate Running Totals:    • How to calculate running total in pow...  
3.Duplicate Vs Reference :    • power bi difference between duplicate...  
4.Merge Vs Append:    • power bi difference between merge and...  
5.Calculate Function in DAX Power BI:    • What is Calculate Function in Power B...  
6.Filter Function in Power BI:    • Filter Function in Power BI DAX  
7.Row Vs Filter Context:    • Row Context Vs Filter Context in Powe...  

Download the pbix file used in this video from: https://drive.google.com/file/d/1LJsV...