Forum Discussion
Why does the ALL function fail in this case?
I have in my table the column "duration" that shows the total minutes used per month. And the "measure" column I want to show the total minutes used per quarter.
When I run the ALL function to except the months, it gives me the same value as the first column... Why is this happening?
| MEASURE = CALCULATE(SUM('table'[Duration]), ALL(Calendar[MONTH])) |
I would like to see something like this
Hi Chris123Terr ,
Please try:
MEASURE = CALCULATE(SUM('table'[Duration]), ALLEXCEPT('Calendar','Calendar'[TRIMESTRE]))Or:
MEASURE = VAR _total = CALCULATE(SUM('table'[Duration]), ALLEXCEPT('Calendar','Calendar'[TRIMESTRE])) VAR _max = CALCULATE(MAX('Calendar'[Month Number]),ALLEXCEPT('Calendar','Calendar'[TRIMESTRE])) VAR _month = MAX('Calendar'[Month Number]) VAR _result = IF(_max=_month,_total) RETURN _resultBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
1 Reply
Hi Chris123Terr ,
Please try:
MEASURE = CALCULATE(SUM('table'[Duration]), ALLEXCEPT('Calendar','Calendar'[TRIMESTRE]))Or:
MEASURE = VAR _total = CALCULATE(SUM('table'[Duration]), ALLEXCEPT('Calendar','Calendar'[TRIMESTRE])) VAR _max = CALCULATE(MAX('Calendar'[Month Number]),ALLEXCEPT('Calendar','Calendar'[TRIMESTRE])) VAR _month = MAX('Calendar'[Month Number]) VAR _result = IF(_max=_month,_total) RETURN _resultBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data