CODEWITHSUNDEEP
excelpowerpivotdax
Seb Taylor
Seb Taylor

Reputation: 19

Excel table filters not recognised in PowerPivot measures

I'm trying to create a parameter table to change the units the figures in my pivot table are presented in. I have:

Both tables are in my data model.

I added the Units Column B as a slicer to TransTBL, despite the fact they have no connections.

I then tried to create a measure in the Units table on the PowerPivot side to recognise which slicer option was chosen. My measure won't recognise the slicer selection. However it will recognise the filter if I apply it directly to the table in PowerPivot.

I'm using the HASONEVALUE function as described here.

Upvotes: 0

Views: 39

Answers (1)

Foxan Ng
Foxan Ng

Reputation: 7151

The measure works fine as expected. 

AmountDisplay = 
IF(
    HASONEVALUE(Units[B]),
    SUM(TransTBL[Amount]) / VALUES(Units[A]),
    SUM(TransTBL[Amount])
)

result

Can you provide more details on your data or model to see if there are any specific problems associated?

Upvotes: 0

Related Questions