Forum Discussion
Black3y
Microsoft Employee
Microsoft EmployeeMeasure as Column in Matrix
Hi all, I can see from various other threads that there is no simple way to use a Measure as a column in a matrix. I have looked at the "Disconnected table trick" post but I am struggling to mak...
- @Black3y
Is a composite model a possibility for this report? https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
If so, you could create an allocation table to do this.
Otherwise, you can't measure columns in Power BI. You could put it in Values, but for it to work for the screenshot you've posted, you'd have to create a separate measure for each MoM$ Month (for example, July Mem $, August MoM $, etc.) otherwise you'll end up with the repeated project name for each month.
I guess another option would be to turn off automatic resizing of column widths and make additional project columns result from hidden values as suggested by @Greg_Deckler
Does any of that make sense?
Black3yMicrosoft Employee
Microsoft EmployeeI will try again...
I use the folliing query to create a new meansure called Project Name as "subscription name" means very little to my users.
Project Name = If(CONTAINS('Subscriptions','Subscription'[Subscription Name],"XXXXX"),"New Project Name"
They can then use the report and look at their "Projects".
Desired result below... simply replacing the content of "Subscriptions" field with the contents of "Project Name"
Greg_Deckler
Community Champion
Community ChampionBlack3y Yeah, I don't see that happening without it being a composite model per AllisonKennedy