Forum Discussion
Solved
Use a Matrix to Display Values - Divisor is Fixed
I am using a matrix to display values for a report that contains sales and quantity data based on Type, Category, Subtype, Line Item. Here is a link to a pbix containing mock data and my attempt at ...
ConnieMaldonado , Try a measure like
calculate(Sum(Table[Qty]), filter(all(Table), Table[Item] = max(Table[Item Type]) ))
or
calculate(Sum(Table[Qty]), filter(all(Table [Item]), Table[Item] = max(Table[Item Type]) ))
ConnieMaldonado , Try a measure like
calculate(Sum(Table[Qty]), filter(all(Table), Table[Item] = max(Table[Item Type]) ))
or
calculate(Sum(Table[Qty]), filter(all(Table [Item]), Table[Item] = max(Table[Item Type]) ))
I'll give that a try tomorrow. Thanks for the response!
I was also thinking - what if I create a table using the summarize function that creates the sums as I need them, and then link back to the table or do a lookup to get the divisor. What do you think about that (if I can't get the measure to work)?
Thanks!