Complex Matrix with multi variables

[Anonymous]

My goal is to create a table like the one below.

The problem is, that each 'cell' should include three elements:
1) & 2 ) a combination of two different variables (Realized and Goal)
3) separated by a ' / '

It's easily done in excel, but can it be replicated in Power BI? 
Thanks.

[v-lili6-msft · Accepted solution]

HI, @Anonymous 

You could get in a matrix visual.

Realized and Goal are two measure? if so use this formula to create a new measure to combine them together.

New Measure = [Realized]&"/"&[Goal]

Then drag it to matrix visual.

If Realizedand Goal are not two measure, transform them to measure.

Best Regards,

Lin

[sivapandi]

Table =
ADDCOLUMNS (
    SUMMARIZE ( 'KPI', 'KPI'[Detailed] ),
    "APR", CALCULATE ( MAX ( 'KPI'[Realised] ), 'KPI'[Month] = "APR" ) & "/"
        & CALCULATE ( MAX ( 'KPI'[Goal] ), 'KPI'[Month] = "APR" ),
    "MAY", CALCULATE ( MAX ( 'KPI'[Realised] ), 'KPI'[Month] = "MAY" ) & "/"
        & CALCULATE ( MAX ( 'KPI'[Goal] ), 'KPI'[Month] = "MAY" ),
    "JUN", CALCULATE ( MAX ( 'KPI'[Realised] ), 'KPI'[Month] = "JUN" ) & "/"
        & CALCULATE ( MAX ( 'KPI'[Goal] ), 'KPI'[Month] = "JUN" )
)

hI.,

I used above dax code to create temp table as u want. hope will solve your issue.i got the result as attached image.