Display Data with no Values

Hi Anonymous ,

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

1.Create a calculate table

Table 2 = VALUES('Table'[Department])

2.Create a measure

Count of ID = IF(
    COUNT('Table'[Department]) = BLANK(),
    0,
    COUNT('Table'[Department])
)

3.Create relationship between two tables

3.Create a matrix using Table2[Department] as column and measure as value

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