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.
Hi,
I have a column with difference % values. I want to create a measure that will tell me how many of those values are greater than 50%. Can anyone advise how to do that?
Thanks,
NB1
Solved! Go to Solution.
When you get that error you have to include FILTER in the CALCULATE function.
You can still use @Zubair_Muhammad's measure, but you just need some adjustment:
Measure = CALCULATE ( COUNTROWS ( TableName ), FILTER(TableName, TableName[column] > .5 ))
Try with following
Measure = CALCULATE ( COUNTROWS ( TableName ), TableName[column] > .5 )
@Zubair_Muhammad thanks, however i'm still getting an error message: "A function CALCULATE has been used in a True/False expression that is used as a filter table expression. This is not allowed."
The column I want to filter by values that are >/< 50% is itself a calculated column. Does that change the DAX formula that needs to be used?
When you get that error you have to include FILTER in the CALCULATE function.
You can still use @Zubair_Muhammad's measure, but you just need some adjustment:
Measure = CALCULATE ( COUNTROWS ( TableName ), FILTER(TableName, TableName[column] > .5 ))
No it shouldn't matter if its a column or a calculated colum
Did you add the Formula as a MEASURE or calculated column
Could you show me the screen shot of your Table?
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |