Forum Discussion
Solved
Measure 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?
Black3y , Not very clear, but seems like a case of bucketing.
If so you need have measured and then join that measure with and independent table to use that independent tables and you have do it for all measures.
You can refer this example
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
thanks @amitchandak - those links look good but I am not sure I am not sure I know how to use it in this example... I will take a look though.