Table to show in different way in Dashboard

[rms1]

I have a table where I have to show Blank rows records in Header with Count and also all rows should be with Text Count as below.

TableApple

Column1     Column2

Apple           Blank (No Value)

Apple           American

Apple           Indonesian

Apple           Argentina

Apple           Blank (No Value)

Apple           American

Apple           Argentina

Apple           American

Apple           Blank (No Value)

Apple           Indian

Apple           Blank (No Value)

Apple           American

Apple           Indian

Apple           Argentina

Apple           Blank (No Value)

--------------------------------------------

Result Should be as below :

Apple(5)-->Header of Table Header in Visual in Report Pane
American(4) -> row
Indonesian(1) -> row
Argentina(3) -> row
Indian(2) -> row

[v-chuncz-msft · Accepted solution]

@rms1,

You may try the Matrix visual and use measure below.

Measure =
IF (
    ISINSCOPE ( TableApple[Column2] ),
    COUNT ( TableApple[Column2] ),
    COUNTROWS ( FILTER ( TableApple, ISBLANK ( TableApple[Column2] ) ) )
)