Reply
Frequent Visitor
Posts: 4
Registered: ‎12-05-2018
Accepted Solution

Table to show in different way in Dashboard

[ Edited ]

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


Accepted Solutions
Community Support Team
Posts: 4,023
Registered: ‎07-09-2016

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.

View solution in original post


All Replies
Community Support Team
Posts: 4,023
Registered: ‎07-09-2016

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.