Forum Discussion

id013's avatar
id013
Helper V
5 years ago

Blank Rows in Matrix still showing up

Hi,

So I have a visual with multiple measures created and I've implemented a method to hide and show the measures based on a measure selector, based on the following youtube --> https://www.youtube.com/watch?v=OIGGrrnMIgk&ab_channel=BIElite

 

Each measure has the following Logic:
Measure = 
VAR LogicTest = 
COUNTROWS(DISTINCT(
FILTER(ALLSELECTED(Measures[Selection]),
Measures[Selection] = "Measure1"
)

)) = 1

RETURN 
IF(
      LogicTest, [Sum of Measure 1],BLANK()
)

 

Unlike the video, I wanted it done in a matrix. The problem is while the value of the measure goes blank, the measure name in the matrix sticks around so there's just a whole row of blanks. Is there a way to implement this so the whole row is blank? 

So the first is with all measures selected so it shows both Measure 1 & 2, the second is with only measure 2 selected. Ideally if I have Measure 2 selected, then the row for Measure 1 should be completely blank not just the values.

 

Thanks

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    id013 are you using shows on rows in Matrix visual or measure 1 and measure 2 are actual columns from the disconnected tables?

    • id013's avatar
      id013
      Helper V
      5 years ago

      Hi,

      Yes I'm using show on  rows. However I've found that it is blank whether I use on rows or not. Measure 1 and Measure are created measures.

      Thanks

      • id013's avatar
        id013
        Helper V
        5 years ago

        So I tried a different way to do this, instead for I'm calculating the measure as follows: 

         

        =SWITCH(SELECTEDVALUE(measures[selection]),"Measure1",[Sum of Measure 1],"Measure 2",[Sum of Measure 2], BLANK())
         
        This behaves in the manner that I want where 1) any blank rows don't show up and 2) All the measures are grouped under the Year like the following:
         2019/20202020/2021
        Store1Measure1 Measure2Measure1 Measure2
        Store2Measure1 Measure2Measure1 Measure2
        Store3Measure1 Measure2Measure1 Measure2

         

        The only Issue I have now is the the total row at the bottom doesn't total anything up for the selected measures. Is there any way to do this with the total row actually working?

         

        Thanks