Exclude help

[pawwy1415]

Hi Experts,

Can any one please help me on Below issue.

I have applied the Two default filters Date and Prioritisation in the app.

In the below chart I have to exclude Prioritisation = '2019 Delivery Plan' default seletion and need to show all prioritisations.

I have done like below

Dimension: Prioritisation

Measure: Count({<Prioritisation=>}Distinct ID)

But its not working. Is there any other way to exclude the default selection from the above measure.

Please help me on this.

Thanks in advance.

[Vegar]

Could it be that Report Date that is reducing your Prioritisation down to only '2019 Delivery Plan' as well. 

If it is only '2019 Delivery Plan' available for 21/10/2019 then you will only see that value. If you want to ingore Report Date as well then you have to use this expression:

Count({<[Report Date]=, Prioritisation=>}Distinct ID)

[MohammedMustaq]

Try this

Exclude

Measure:  Count({<Prioritisation-={'2019 Delivery Plan'}>}Distinct ID)

Thanks

Mustaq

[sunny_talwar]

May be this if you always want to see all other Prioritisation except 2019 Delivery Plan in your chart regardless of selection made in Prioritisation field

Count({<Prioritisation = -{'2019 Delivery Plan'}>}Distinct ID)

else this

Count({<Prioritisation -= {'2019 Delivery Plan'}>}Distinct ID)