The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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
User | Count |
---|---|
159 | |
109 | |
96 | |
84 | |
75 |
User | Count |
---|---|
157 | |
137 | |
131 | |
81 | |
61 |