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....
Need Help
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 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi id013 

      Is your issue that the total row in your matrix show nothing if you use the new measure?

      I build a sample to have a test, and my result show totals well.

      I think this may be caused by your measures, [Sum of Measure1] and [Sum of Measure2].

      You can try to add only [Sum of Measure1] or [Sum of Measure2] into value field in your matrix and check whether these two measures will return total correctly.

      You can try to sum your measure, and normally the total row will return corret result.

      For example:

      Sum [measure1] = sumx(Table, [Sum of Measure1])

      If this reply still couldn't help you solve your problem, please share a sample with me by your Onedrive for Business.

       

      Best Regards,

      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.