How to insert rows in Power BI Matrix to show minimum and maximum values

[sumitnegi1266]

Hi,

I have below data and need to display extra rows showing minimum and maximum for each set. I am also using company slicer, so if company A and Company B are selected, it should show minimum and maximum as per the data filtered in Power BI matrix.

My Data:

Expected Output:

[sumitnegi1266]

Thank you so much @Ahmedx, it works as expected now 🙂

[sumitnegi1266]

@AhmedxThanks for sharing the pbix. The only issue with this is, when I select companies under Set 1, it should give the minimum and maximum from those selected companies. In the screenshot below, the minimum for Set 1 should be 10. Also, the min and max should appear only once.

[Ahmedx]

pls try this
https://1drv.ms/u/s!AiUZ0Ws7G26Rijc76j-np9aWnkBQ?e=9FYbtJ

[sumitnegi1266]

@Ahmedx It is still showing incorrect results. For company A and Company B selected, the maximum should be 30, but it is currently showing 50.

[Ahmedx]

everything shows correctly

[Ahmedx · Accepted solution]

try this

https://1drv.ms/u/s!AiUZ0Ws7G26Rijc76j-np9aWnkBQ?e=UqwSfU

Final = 
VAR _min =
    CALCULATE ( MIN ( 'Table'[Value] ), ALLSELECTED('Table'[Set] ) )
VAR _max =
    CALCULATE ( MAX ( 'Table'[Value] ), ALLSELECTED('Table'[Set] ) )
RETURN
    SWITCH (
        TRUE (),
       SELECTEDVALUE ( DimCompany[Company] ) = "Minimum", _min,
      SELECTEDVALUE ( DimCompany[Company] ) = "Maximum", _max,
        CALCULATE (
            [Sales],
            TREATAS ( VALUES ( DimCompany[Company] ), 'Table'[Company] )
        )
    )

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RijYWQyfB8iSBT4ef?e=XiaJWg