Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I have created a visual where I use measures. I then want a total of the measure which doesn't come out right. See snapshot attached. Basically having a challenge to get the right grand total for a "calculated measure". The total of the measure is not really sum of this measure, but instead calculated at a row level...sorry if I have made it more convoluted but any help would be appreciated.
Solved! Go to Solution.
Hi @chaturchavas ,
As far as i know, this ’total‘ does not calculate the sum of the measure, if you want to calculate sum of measure, please use
sumx('table',measure)
For example:
Measure = MAX('Table'[Column1])/MAX('Table'[Column2])
Measure 2 = SUMX('Table',[Measure])
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@chaturchavas Not sure what is the logic for your measure but can you please try to use SUMX instead of SUM. If SUMX doesn't work please share the measure logic and some sample data to reproduce the scenario
Hi Vimal,
Here is some explanation:
All the columns (Except Material Number) are calculcated measures from the base table. Price Per Unit Difference is difference between the Price Per Unit 2019 and Price Per Unit 2018.
Inflation by Line is another measure = Price per unit difference * Net Order Qty 2019
Hi @chaturchavas ,
As far as i know, this ’total‘ does not calculate the sum of the measure, if you want to calculate sum of measure, please use
sumx('table',measure)
For example:
Measure = MAX('Table'[Column1])/MAX('Table'[Column2])
Measure 2 = SUMX('Table',[Measure])
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |