cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rms1 Frequent Visitor
Frequent Visitor

Table to show in different way in Dashboard

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Table to show in different way in Dashboard

@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] ) ) )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Table to show in different way in Dashboard

@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] ) ) )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.