Forum Discussion
Solved
Calculate with all function, maintaining filters applied
I am trying to calculate the sum of revenue for 2022 of a all products given that they have sales in a given periode (after 30.06.2022). That is measure [Price 30.06] is not blank or 0. The ...
Apologies, part of my inital syntax was incorrect, what solved it was the following:
CALCULATE(Revenue ,Dates[Year]==2022, KEEPFILTERS(Products[Products_ID] <>BLANK()), FILTER(ALL(Products), 'Price analysis'[Price 30.06] <> BLANK())),0)
Apologies, part of my inital syntax was incorrect, what solved it was the following:
CALCULATE(Revenue ,Dates[Year]==2022, KEEPFILTERS(Products[Products_ID] <>BLANK()), FILTER(ALL(Products), 'Price analysis'[Price 30.06] <> BLANK())),0)