Forum Discussion
DAX Measure SUM Using Matrix Visual
I'm Using Matrix Visual in PBI as such:
Rows: Record[Asset], Record[Date]
Columns: Record[Column1], Record[Column2]... Measures
I have Record and Assets tables. There is a relationship between the two. Record[Asset] and Assets[Assset].
When I use the drill down with Matrix visual, my columns are properly SUMMED together. I need to create a measure that will also get summed based on the drill-down level.
Measure = Record[Value1] / Assets[Info1] * Record[Value1] is what I want my measure to do.
How can I set this measure, so that for each asset in the columns of my matrix visual, it calculates this and properly sums when drilled up.
1 Reply
I'm afraid the formulation of the problem is too... well, foggy for anyone to try to give you an answer. Please rephrase the problem. This might help: https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-p/1626726
