Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey all, looking to ignore a selection in a chart as I would like to show all items from the select group in this specific chart.
Example: IF((vDimension_Period) ='FX_Rates_YearMonth',AVG([Exchange_Rate]),
I want to ignore the( [Exchange _Rate]) field. I have tried adding = to the end but this hasn't worked, can anyone shed any light on this?
Id either like to ignore the field or have an expression that allows me to show all of this particular measure.
Thanks 🙂
If you want to ignore the user selection in a specific field, then you should use a set expression inside your aggregation function:
Avg({<[Exchange_Rate]=>} [Exchange_Rate])
If you want to ignore the user selection in a specific field, then you should use a set expression inside your aggregation function:
Avg({<[Exchange_Rate]=>} [Exchange_Rate])
@Cameron94 it would be something like below:
Avg({<[Exchange_Rate]=,vDimension_Period={'FX_Rates_YearMonth}>} [Exchange_Rate])
If it resolves your issue, please like and accept it as a solution.