Multiple values in the same cell (value and %)

[jayala]

Hello guys,

I am wondering if is there is a way to show multiple values in the same cell using a Matrix.

I have price and discounts as two separated rows and I also want to show the percentage of that discount over the price in the same cell inside brackets.

Do you know any way to do it?

Thank you in advance.

[v-frfei-msft · Accepted solution]

Hi @jayala ,

Please create a measure as below.

Measure = 
VAR va =
    SUM ( 'Table (2)'[value] )
VAR p =
    MAX ( 'Table (2)'[p/d] )
VAR pva =
    CALCULATE (
        SUM ( 'Table (2)'[value] ),
        FILTER (
            ALLEXCEPT ( 'Table (2)', 'Table (2)'[Month] ),
            'Table (2)'[p/d] = "Price"
        )
    )
RETURN
    IF (
        p = "discounts",
        va & "("
            & FORMAT ( ROUND ( va / pva, 2 ), "Percent" ) & ")",
        va
    )

Pbix as attached.

[jayala]

Hi @v-frfei-msft thank you for your help.

It looks pretty good. I will have to think my dataset structure again to implement it.

[mwegener]

Hi @jayala ,

you could create a Text Measure.

Discount Label =
IF (
    ISBLANK ( [Discount] ),
    BLANK (),
    FORMAT ( [Discount], "0" ) & " ("
        & FORMAT ( [Discount %], "0%" ) & ")"
)

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.