Hi Folks,
I have a scenario where I have a filter on my dashboard for "Type" giving me three different units of measurement.
When writing my DAX however I've included only the "Forecast RXN" meaning everytime I switch my filter type, the Forecast remains the same across all units of measurement.
I need to include two more clauses in my DAX to incoporate the other two units of measurement. Please see below:
Cheers folks.
Sounds like you want to learn about Calculation Groups?