Forum Discussion

NK2603's avatar
NK2603
New Member
2 years ago
Solved

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 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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

2 Replies

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    2 years ago

    Hi NK2603,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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