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 only showing the total number. 

may i know how to appear same as the orginal number by each province ? 

 
measure1 = CALCULATE(IF(ISFILTERED('Retails Audit'[PRODUCT NAME]),[+/-ND...],[+/-Avg ND]),ALLSELECTED('Retails Audit'))

 

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.

1 Reply

  • 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.