I’m trying to display a list of measure names as dimension names in rows. So I created new table in DAX using the UNION and ROW functions. Here is a snippet :
ROW( “CAUSES” , “OTHER”, “VALUES” , [Other HM] ),
ROW( “CAUSES” , “CHARGE_AVG”, “VALUES” , [Charge avg.] )
The problem is that the measures are not filtered when added to the report (VALUES column).
I would like to have a table like this :
Note that the values under CAUSES do not exist in my Fact table. This is a new type of dimension that the client would like to analyse their data by. I thought by creating a table in DAX, I could set the row values (CAUSES) and add the necessary measure but unfortunetely that does not work.
The measures filter correctly when added directly to the report, example with a Card graphic.
Any ideas ?