Complex multiple measure Matrix

[AWK7]

Hi all,

Long time lurker, first time poster.

I have a need to create a matrix that displays data in an identical way to the image included.

The closest I have come to replicating this is found in the following thread: https://community.fabric.microsoft.com/t5/Desktop/Combine-multiple-measures-in-a-single-matrix/td-p/...

Using this, I have made a "Row" table and "Category" table. The Rows correspond with Row 1-4. Category is Month, Year to Date and Full Year forecast. Finally, I was picturing using measures for Actual, Budget, Variance.

I have included a snip of my current attemp (don't mind the numbers as I was attempting to use IF statements with not much success.

I thought something like: 

IF ( SELECTEDVALUE ( RowTable[Row] ) = "Row 1" && SELECTEDVALUE(CategoryTime[Category]) = "Month", [Measure] ,

But this works once and doesn't really help me populate the rest of the table.

Any help appreciated.

Snip of what I'm trying to create in Power Bi vvv

Power Bi attemp vvv

[Anonymous]

Hi @AWK7 ,

Can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...