Power Pivot: Slicer not working when using IF with ISBLANK

[jon999]

Hi

I have two slicers one called Organisation and the other called Division. When I filter based on Organisation the Division list does not change and shows all divisions and does not filter just the divisions that relate to the Organisation.

I have used the below measure but this does not work.

IF (
COUNTROWS ( Division ) > 0,
IF ( ISBLANK ( SUM ( Data[AUD] ) ), 0, SUM ( Data[AUD] ) )
)

I also have the same measure with USD and then use SWITCH to use a slicer to move between AUD or USD.

I have a table called Data (has columns with AUD, USD, Organisation and Division) and two other tables called Organisation and Division which I have made a relationship with Data.

Thanks

Jon

 

[SyedUsman]

Have you connected both the slicers to the Pivot table?

 

[jon999]

Yes I have.