Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Matrix table

Hi,   I used matrix to make this table. Then I added 2 values from my data to "rows" and then drill down and thats how I have O&G as the section and borstar as the sub.   Well for some reason O&G...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous on format pane, turn off row total and that will take care of it.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k Yes, but some of them need to be there. I don't want to delete all of the row totals when I need some

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous that is possible, in that case your each value field you have to put condition and return blank value where you don't want to show the total.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      parry2k How do I do this? Where? Can you walk me through this please

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Anonymous here is example of one of the measure, instead of Duration field, use following Duration Measure and you will see in case of "O&G", it will give you blank() value, and you have to create similar measure for each and every Field you are using Value pane in matrix visual.

         

        Duration Measure = 
IF( NOT SELECTEDVALUE( Table[Active Projects] ) IN { "O&G", "ABC", "XYZ" } ),
SUM( Table[Duration] 
)