DAX- How to return selected measure values in a table?

[Anonymous]

Hi All,

----please refer below picture------

I am trying to create a measure that, if I select anything from Product Name filter visual, it will return (%)PRODUCT Measure, if there isnt anything selected in Product Name filter visual then it will return (%)SUB-PRODUCT Measure.  

Below case, I tried to use ISFILTER Function like below;

Measure =

        IF (ISFILTERED(PRODUCT[PRODUCT_NAME]),(%)PRODUCT,(%)SUB-PRODUCT) 

And, it didnt work.  I didnt select anything from filter visual, but it is returning (%)PRODUCT. 

Note: I need to keep PRODUCT NAME in the table

Do you have any solution?

Thank you!

[amitchandak · Accepted solution]

@Anonymous , Product name is used in visual, so isfiltered is true because of that

try like

var _is = calculate(ISFILTERED(PRODUCT[PRODUCT_NAME]), allselected())

return

IF (_is ,(%)PRODUCT,(%)SUB-PRODUCT)