Forum Discussion
NK2603
2 years agoNew Member
Card View
Hello. I am beginner in Powerbi and have one question. How to show in Card "0" if there is no row and data at all in table when filtering in Report view? I am filtering by slicer in Report view and ...
- Anonymous2 years ago
Hi NK2603 ,
Thanks to _AAndrade for the solution.
Here are what i want to add:
Sample DataCreate measures
Measure 2 = IF( COUNT('Table'[Value]) = 0, 0, COUNT('Table'[Value]) )Measure 3 = IF( ISBLANK( SELECTEDVALUE('Table'[Value]) ), 0, COUNT('Table'[Value]) )Final output
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly