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,
In SQL, if you want to show the records which has 0 values, we apply where clause and get the records only applied to this where clause.
and Enrol_count = 0
Similar way,
I want to show the count of records from a field for just 0 values(has 30 records in it).
I am planning to use 'Card' visualization for this, to show the count of rows.
How to do this in Power BI?
Much appreciated. Thanks!
Solved! Go to Solution.
@BBIUser,
Please check if the following DAX returns your expected result. If not, please share sample data of your table and post your desired result.
Measure = COUNTROWS(FILTER(ZeroTFSlLevel,ZeroTFSLevel[PlaceOrPte]="Pte"&&ZeroTFSlLevel[Enrol_count] = 0))
Regards,
Lydia
So, no sample data provided but I will take a wild guess:
Measure = COUNTROWS(FILTER('Table'),[Column]=0))
Thanks @Greg_Deckler. This is exactly what I wanted to use.
What if I want to use another field in the same DAX? Here is what I tried doing but has an error.
ChoiceEnrol2 = COUNTROWS(FILTER(ZeroTFSlLevel, ZeroTFSLevel[PlaceOrPte] = "Pte"), FILTER(ZeroTFSlLevel, ZeroTFSlLevel[Enrol_count] = 0))
@BBIUser,
Please check if the following DAX returns your expected result. If not, please share sample data of your table and post your desired result.
Measure = COUNTROWS(FILTER(ZeroTFSlLevel,ZeroTFSLevel[PlaceOrPte]="Pte"&&ZeroTFSlLevel[Enrol_count] = 0))
Regards,
Lydia
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |