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.
I am able to get count for blank records from two columns but not able from another value exists record
BlankCountmeasure =
CALCULATE(COUNTBLANK('data'[level 2]),FILTER('data','data'[level 1]= "Manager"))
Not working measure as below
FieldEngineerCountMeasure =
CALCULATE(COUNT('data'[level 2]),FILTER('data','data'[level 1]= "Manager")
,FILTER('data','data'[level 2]= "FieldEngineer"))
Solved! Go to Solution.
Hi @rms1
You measure seems to be working perfectly fine.
See the below image.
You can see the PBIX file here.
If you are still facing some issues with your work please share the pbix.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
Hi @rms1
You measure seems to be working perfectly fine.
See the below image.
You can see the PBIX file here.
If you are still facing some issues with your work please share the pbix.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |