Forum Discussion
Solved
LOD Expression from Tableau
hi, I want to create a calculation on top of a LOD expression similar to this. MAXSALES = {Fixed Country : MAX(SALES)} which im doing by MAXSALES = CALCULATE(MAX('Table1''Sales'),ALLEXCEPT('...
Hi mikey268 ,
Try this:
Measure = SUMX(SUMMARIZE('Table'; 'Table'[Quarter]; 'Table'[Part]; "Total"; MAX('Table'[Cost])); [Total])
Hi, thanks for the response. something like this. I would do SUM({FIXED Quarter, Part : MAX(cost)}
| Quarter | Part | Cost |
| 2020Q1 | A | 100 |
| 2020Q1 | A | 100 |
| 2020Q1 | A | 100 |
| 2020Q1 | B | 200 |
| 2020Q1 | B | 200 |
| 2020Q1 | B | 200 |
| 2020Q1 | B | 200 |
| 2020Q1 | C | 300 |
| 2020Q1 | C | 300 |
| 2020Q1 | C | 300 |
| 2020Q2 | A | 200 |
| 2020Q2 | A | 200 |
| 2020Q2 | A | 200 |
| 2020Q2 | B | 100 |
| 2020Q2 | B | 100 |
| 2020Q2 | B | 100 |
| 2020Q2 | C | 400 |
| 2020Q2 | C | 400 |
| 2020Q2 | C | 400 |
Result:
| Result | Part Cost |
| 2020Q1 | 600 |
| 2020Q2 | 700 |
Hi mikey268 ,
Try this:
Measure = SUMX(SUMMARIZE('Table'; 'Table'[Quarter]; 'Table'[Part]; "Total"; MAX('Table'[Cost])); [Total])