Measure Filter is not working

[Chanleakna123]

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'))

[Signore_Ands · Accepted solution]

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.