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 Overriden_value, but don't want the detail for every sub value of CS.

Regards

 

Tips and Tricks

6 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi RomainBSNP 

    Create a measure like (Item is the column which holds data line ACTUAL_PICES ect)

     

     

    Measure = VAR _Item = SELECTEDVALUE(Table[Item])
RETURN
IF(
_Item IN {"ACTUAL_PICES","----","----",so on},BLANK(),YourMeasure or Value COl)

     

     


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

  • 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 ? 

      • 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 !