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.
Solved! Go to Solution.
Hi @Anonymous,
AFAIK, the current DAX expressions are not able to affect the filter/slicer selections. You can't use them to change the selection or cancel current activities items.
If you means to ignore the filter interatiosn from a specific field, you can use isfiltered with all functions to ignore specific filters to affect the DAX formula calculations.
ISFILTERED, ISCROSSFILTERED – DAX Guide - SQLBI
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
BTW, selectedvalue function is suitable for single selection, if you selected multiple items without setting 'alternate Result' it will return a blank result. You can try to use the following formula to show current selections:
Selected PN =
VAR selectedPN =
CONCATENATEX ( VALUES ( DimPnRework[pn] ), [pn], "," )
RETURN
"pn:"
& IF (
COUNTROWS ( VALUES ( DimPnRework[pn] ) )
= COUNTROWS ( DISTINCT ( ALL ( DimPnRework[pn] ) ) ),
"All pn",
selectedPN
)
Regards,
Xiaoxin Sheng
Hi @Anonymous,
AFAIK, the current DAX expressions are not able to affect the filter/slicer selections. You can't use them to change the selection or cancel current activities items.
If you means to ignore the filter interatiosn from a specific field, you can use isfiltered with all functions to ignore specific filters to affect the DAX formula calculations.
ISFILTERED, ISCROSSFILTERED – DAX Guide - SQLBI
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
BTW, selectedvalue function is suitable for single selection, if you selected multiple items without setting 'alternate Result' it will return a blank result. You can try to use the following formula to show current selections:
Selected PN =
VAR selectedPN =
CONCATENATEX ( VALUES ( DimPnRework[pn] ), [pn], "," )
RETURN
"pn:"
& IF (
COUNTROWS ( VALUES ( DimPnRework[pn] ) )
= COUNTROWS ( DISTINCT ( ALL ( DimPnRework[pn] ) ) ),
"All pn",
selectedPN
)
Regards,
Xiaoxin Sheng
User | Count |
---|---|
60 | |
46 | |
19 | |
18 | |
15 |
User | Count |
---|---|
116 | |
41 | |
40 | |
28 | |
22 |