Forum Discussion
Measure total wrong
Hello I created a measure where total is coming wrong. I tried options shown in other posts with has one filter, not working. Any help? My measure looks like Calculate(datediff(firstdate(table1[fie...
- 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 |
Greg_Deckler edhans amitchandak hi guys can you please help in here