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
Icon for Community Champion rankCommunity 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 !

     

      • RomainBSNP's avatar
        RomainBSNP
        Frequent Visitor
        2 years ago

        Seems like we replied at the same time approximatively. See my post above :).