Unpivot Measures (for categorical chart)

[Anonymous]

Hi guys.

I've seen one or two posts with an issue close to this one and there was no solution, but I really think (and hope) that there must be a way around this.

Sooo, I created a few Measures and I would like to create a Radar Chart (custom visual) with them. The problem is that the visual requires categorical data.

If it was the query editor I would unpivot the data.

Is it possible to create a temporary table in DAX and emulate the "UNPIVOT" procedure?

Thanks in advance.

Cheers.

[Zubair_Muhammad · Accepted solution]

@Anonymous

How about a new calculated table from Modelling Tab

Table =
VAR T1 =
    SUMMARIZE ( Table1, [ID], "Measure", 1, "Value", [Measure1] )
VAR T2 =
    SUMMARIZE ( Table1, [ID], "Measure", 2, "Value", [Measure2] )
VAR T3 =
    SUMMARIZE ( Table1, [ID], "Measure", 3, "Value", [Measure3] )
RETURN
    UNION ( T1, T2, T3 )

[Anonymous]

Hey, thanks a lot for your response.

It makes a lot of sense.

But I step on a problem I had before with the SUMMARIZE function. As the measures I use are refering other tables (DIM Tables) with filters, the values I get on those columns out of the SUMMARIZE function are all the same. I created an extra MonthYear column to group by Month.

For example, the measure I used for this one is like:

RANK =
DIVIDE (
    [UNITS] - AVERAGEX ( ALL ( 'DIMTABLE' ); [UNITS] );
    AVERAGEX ( ALL ( 'DIMTABLE' ); [UNITS] )
)

Any idea why this is happening?

Thanks again.

[Zubair_Muhammad]

@Anonymous

Its difficult to understand whats going on

May be if you could share the file with expected output...hopefully someone would be able to find a solution

But I feel that we could summarize the Tables just the way they are summarized in the VISUAL using SUMMARIZE function

Then use "SELECTCOLUMNS" to get relevant columns

and then do a union of these tables

[Anonymous]

I guess I'll have to wait for that. This problem has been bothering me for some time.

Thanks a lot, I marked your post as solution anyway because it could/should have solved my problem, the logic is correct.

Thanks!