Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |