Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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;
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!
Solved! Go to 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)
@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)
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |