Conditional Set Expresion

[jplozano]

Hi guys!

I have a problem with one dashboard. I´m calculating the variation between dates with Set Analysis. This variation can be calculated for 3 distinct clients but i want than the variation value only appears when i select ONLY ONE value.

In other graphics i have more information and i can compare the values for all clientes and i cant force to filter just for a value.

My comparison set analysis is this:

(((Sum({$<Fecha_Valor = {"$(=Date(v_max_date))"}>} [Valor Liquidativo]) - Sum({$<Fecha_Valor = {"$(=Date(v_min_date))"}>} [Valor Liquidativo]))*100)/Sum({$<Fecha_Valor = {"$(=Date(v_max_date))"}>} [Valor Liquidativo]))/100

Valor Liquidativo is my measure.

Fecha_Valor is my time dimension.

Cartera is my new dimension to add.

Could you help me please?

Thank you very much!!

Regards

[petter · Accepted solution]

Maybe this will work for you:

=If( Count(DISTINCT Client)=1 ,

(((Sum({$<Fecha_Valor = {"$(=Date(v_max_date))"}>} [Valor Liquidativo]) - Sum({$<Fecha_Valor = {"$(=Date(v_min_date))"}>} [Valor Liquidativo]))*100)/Sum({$<Fecha_Valor = {"$(=Date(v_max_date))"}>} [Valor Liquidativo]))/100

)

[jplozano]

Hi!.

I applied this solution but i use GetSelectedCount from the new field .

Thank you very much!!

[petter]

Yes GetSelectedCount() is obviously an alternative way of doing it - should actually be slightly faster too.