Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
4 years ago
Solved

Measure Filter is not working

hi all ,    my purpose is to appear [+/-Avg ND] measure when i didn't select anything , but when i select the product name it will appear the number under [+/-ND...] , but the formula i'm using is ...
Need Help
  • Signore_Ands's avatar
    Signore_Ands
    4 years ago

    Hello Chanleakna123 

    I could replicate your issue with my own data, and then fix it after.
    It's an issue with the ALLSELECTED piece.  If I copy your syntax ALLSELECTED(TableName) then I get the same issue, if I change that to be column specific then it works  ALLSELECTED(TableName[ColumnName]). 

    Try ALLSELECTED('Retails Audit'[PRODUCT NAME]) 

    Using ALLSELECTED('Retails Audit') will override the row level filters in the matrix.

Signore_Ands's avatar
Signore_Ands
Advocate III
4 years ago

Hello Chanleakna123 

I could replicate your issue with my own data, and then fix it after.
It's an issue with the ALLSELECTED piece.  If I copy your syntax ALLSELECTED(TableName) then I get the same issue, if I change that to be column specific then it works  ALLSELECTED(TableName[ColumnName]). 

Try ALLSELECTED('Retails Audit'[PRODUCT NAME]) 

Using ALLSELECTED('Retails Audit') will override the row level filters in the matrix.