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