topic Re: Complex multiple measure Matrix in DAX Commands and Tips

Complex multiple measure Matrix

AWK7 — Tue, 25 Jun 2024 03:39:17 GMT

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/2170694

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

Re: Complex multiple measure Matrix

lbendlin — Wed, 26 Jun 2024 00:43:48 GMT

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-Forum/ba-p/963216

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/1447523

Re: Complex multiple measure Matrix

Anonymous — Fri, 28 Jun 2024 07:21:42 GMT

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