Forum Discussion
Measure total wrong
- Yes,its measure total problem. When I added if( hasonefilter (table1[field1) at the front of created measure, total row goes away. For now I am okwith that
Hello
I got the measure total value wrong for one of a column in my Matrix Visual ( Column Name: CALC PRICE), which should be 0.22. Below is the matrix table and measure used to calculate that column
CALC PRICE = SUMPRICE * CALC
SUMPRICE = SUM ('TABLE'[PRICE])
CALC = DIVIDE ([SUMQTY , SUMQTYALL, BLANK())
SUMQTY = SUM('TABLE'[QTY]) & SUMQTYALL = CALCULATE(SUM('TABLE'[QTY],ALLSELECTED('TABLE'))
CAN ANYONE HELP IN HERE TO GET THE CORRECT COLUMN TOTAL!!
| Year | Month Number | Site | SKU | QTY | PRICE | CALC QTY | CALCULATION (CALC QTY) | CALC PRICE | CALCULATION (CALC PRICE) |
| 2020 | 1 | A | 1234 | 17850 | 0.13 | 0.235178 | 17850/75900 | 0.0305731 | 0.235178*0.13 |
| 2020 | 11 | B | 1234 | 17850 | 0.13 | 0.235178 | 17850/75900 | 0.0305731 | 0.235178*0.13 |
| 2020 | 3 | C | 1234 | 17850 | 0.13 | 0.235178 | 17850/75900 | 0.0305731 | 0.235178*0.13 |
| 2020 | 6 | D | 1234 | 3700 | 0.32 | 0.048748 | 3700/75900 | 0.0155995 | 0.048748*0.32 |
| 2020 | 7 | E | 1234 | 18650 | 0.44 | 0.245718 | 18650/75900 | 0.1081159 | 0.245718*0.44 |
| TOTAL | 75900 | 1.15 | 1.15 |
Nimish First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
You might want to post this as a new post along with sample data, etc. This is a 3 year old thread that was closed.