create matrix dashboard with single measure

[PSan1979]

Hi Experts,

i want to create a matrix dashboard as given below.i have created 

Custom Hierarchy = {("SCORE","ACT"),("SCORE","FST"),("SCORE","%AF"),("PROJ","ACT"),("PROJ","FST"),("PROJ","%AF"),("SCH","XXX"),("SCH","YXZ"," ")}

I am stuck here. I want to create a single measure and it should populate the data by matching up Value 1(score,proj,sch) Value2(act,fst.....).

[v-deddai1-msft]

Don't @PSan1979,

You can use the SWITCH function to your measure. Please try something like:

Measure = SWITCH(True(),MAX('Table'[Value1]) = "SCORE"&&MAX('Table'[Value2]) = "ACT",....,MAX('Table'[Value1]) = "SCORE"&&MAX('Table'[Value2]) = "FST",.......)

If you need an accurate formula, show us sample data or onedrive pbix file for business if possible.

If this post helps, then consider Accept it as the solution to help other members find it faster.

Best regards

Dedmon Dai

[amitchandak]

@PSan1979 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Matrix should help: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

For column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795