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 guys,
I am using a card visualization to show the count of rows, but some tables simply do not have any qualified row. Is there a way I can have it shown as 0 instead of <blank>. BTW, the dropdown is frozen. Can someone help on this?
Thanks so much.
Solved! Go to Solution.
Hi @ChenChristyYu,
Seems you added the column in the filed directly. Maybe you need a measure like this:
Measure = IF ( ISBLANK ( COUNT ( Table1[DATE] ) ), 0, COUNT ( Table1[DATE] ) )
Best Regards,
Dale
Hi @ChenChristyYu,
Seems you added the column in the filed directly. Maybe you need a measure like this:
Measure = IF ( ISBLANK ( COUNT ( Table1[DATE] ) ), 0, COUNT ( Table1[DATE] ) )
Best Regards,
Dale
@ChenChristyYu Be cautious with this because it could impact the calculations in other areas in unwanted ways, but you can just throw a "+0" at the end of the equation in the measure and it should produce a 0 instead of blank.
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.