Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Dealing with Measure Totals

This one has come up quite a bit recently. The issue surrounds using Measures in Table visualizations with a Total row. The complaint is that the "Total" row is "wrong" for the measure. Technically, ...
BellaLauritsen's avatar
BellaLauritsen
Regular Visitor
5 years ago

I have a similar problem and can't get it to show the correct total. 

I need to calculate Possible Turnover. 

 

I have a measure calculating quantity on sales order - quantity on purchase order. 

I have a table with all sales prices listed. 

 

I created a measure: 

SUMX('Sales Price Dim - SPD','Sales Price Dim - SPD'[Standard Price (LCY) - SPD]*[Available QTY (POT-SOT) - POT])
 
I have tried with the HASONEFILTER, but can't seem to succeed. Help 🙂