Card View

[NK2603]

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 some items dont have data records in table and at the moment Card shows as "(Blank)" for those items. I need them to show as 0.

Thank you in advance.

[Anonymous · Accepted solution]

Hi @NK2603 ,
Thanks to @_AAndrade  for the solution.
Here are what i want to add:
Sample Data

Create 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 He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[_AAndrade]

Hi @NK2603,

Try somethinh with IF formula, for example:
IF ( COUNTROWS( Name of your table) = 0, 0)