Pie chart ignoring filters

[nbuscemi]

Hi,

I have a pie chart with the following expression in measure: if (TIP_NUM = 'Empl', SUM(Amount).

I want the pie does not change when I filter for THERAPEUTICAREA and REGION, I've tried this: if (TIP_NUM = 'EMPL',  SUM({< THERAPEUTICAREA =, REGION = >} AMOUNT))

but no success.

Can you suggest something?

Thanks.

[Prashant_Naik · Accepted solution]

Hi,

This might help : Sum({<TIP_NUM={'EMPL'},THERAPEUTICAREA =, REGION = >}Amount)

Regards,

Prashant

[nbuscemi]

This worked!!! Thanks😀