Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
My requriment to show count of employees whose variance amount less than $1M ,so to achieve this i'm doing calculations of actuals & forceast, variance in 3 measure columns. so in return function should i write
If(variance < 1.0 ,calculate(distinctcount(employee), table(all)), 0).?
Measure1 actuals = group by (date, location, service interval, name, actuals)
Measure 2 Forecast = group by (date, location, service interval, name, forecast)
Measure 3 variance = actuals/forecast
Thanks
VS
Solved! Go to Solution.
Hi @refint650
You can achieve this using following measure:
Measure = CALCULATE ( DISTINCTCOUNT ( 'Table'[Employee Name] ) , FILTER ( 'Table' , 'Table'[Amount] < 1 ) )
Hope this helps!
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi, @refint650
When Actuals, Forecast, and Variance are all Measure, you can also try the following methods.
Measure =
IF (
[Measure Variance] < 1,
CALCULATE (
DISTINCTCOUNT ( 'Table'[Name] ),
FILTER ( ALL ( 'Table' ), [Measure Variance] < 1 )
),
0
)
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Hi @refint650
You can achieve this using following measure:
Measure = CALCULATE ( DISTINCTCOUNT ( 'Table'[Employee Name] ) , FILTER ( 'Table' , 'Table'[Amount] < 1 ) )
Hope this helps!
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi,
Try this measure
=countrows(filter(values(Data[Name]),[Variance]<1))
Hope this helps.
Hi @refint650
You can achieve this using following measure:
Measure = CALCULATE ( DISTINCTCOUNT ( 'Table'[Employee Name] ) , FILTER ( 'Table' , 'Table'[Amount] < 1 ) )
Hope this helps!
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi, @refint650
When Actuals, Forecast, and Variance are all Measure, you can also try the following methods.
Measure =
IF (
[Measure Variance] < 1,
CALCULATE (
DISTINCTCOUNT ( 'Table'[Name] ),
FILTER ( ALL ( 'Table' ), [Measure Variance] < 1 )
),
0
)
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Hi @refint650
You can achieve this using following measure:
Measure = CALCULATE ( DISTINCTCOUNT ( 'Table'[Employee Name] ) , FILTER ( 'Table' , 'Table'[Amount] < 1 ) )
Hope this helps!
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |