Forum Discussion

RomainBSNP's avatar
RomainBSNP
Frequent Visitor
2 years ago

How to hide some rows values in a Matrix

Hello everyone, Using PowerBI Desktop, I wonder If I can hide the values showing up in red area below : I want to keep the total of each CS Average theoretical_value_for_tr and Average of Ove...
Tips and Tricks
RomainBSNP's avatar
RomainBSNP
Frequent Visitor
2 years ago

Hello and thank you for a quick answer ! Sorry for my lack of knowledge, but I'm not getting the end of the measure :

I tried to set the Overriden valeur as last parameter of the measure, but it is not working. Can you explain a little bit more so I understand this part ? 

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    RomainBSNP 

    After BLANK(),SUM(your column))

     

    • RomainBSNP's avatar
      RomainBSNP
      Frequent Visitor
      2 years ago

      Ok I understand now.

      Unfortunately I have this error when trying to put the measure in the matrix :

      Calculation error in measure 'Mesures'[measure]: Function 'CONTAINSROW' does not support comparing values of type Text with values of type Number.

      The Overriden and theoretic value are set as decimal number, because I need to get the total of it at some point, so I cannot set it to Text.

      I also tried : 

      Measure =
      VAR _Item = SELECTEDVALUE(SHIPMENT_CFV[Overriden valeur])
      RETURN
          IF (
              _Item IN {"MPL_BY_WIDTH", "PIECES"},
              BLANK(),
              SUMX(SHIPMENT_CFV, VALUE(SHIPMENT_CFV[Overriden valeur]))
          )
      Not working better..

      If you have any more ideas, i'll take it !