DAX Measure SUM Using Matrix Visual

numersoz — Fri, 16 Jul 2021 18:29:09 GMT

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.

Re: DAX Measure SUM Using Matrix Visual

daxer-almighty — Sat, 17 Jul 2021 12:21:53 GMT

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

topic DAX Measure SUM Using Matrix Visual in DAX Commands and Tips

DAX Measure SUM Using Matrix Visual

Re: DAX Measure SUM Using Matrix Visual