Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to get that table to not show anything until it is being filtered by either the DESCR slicer or the Map being clicked on, because otherwise it's 11k+ entries. I feel like I must be missing something...
Solved! Go to Solution.
hi @dpiechowski
You could just adjust the formula as below:
m.Hide? =
IF (
CALCULATE ( ISFILTERED ( INVENTORY_BIN[DESCR] ), ALLSELECTED ( INVENTORY_BIN ) ),
1,
IF (
CALCULATE ( ISFILTERED ( BIN_LIST[Zone/Tower] ), ALLSELECTED ( BIN_LIST ) ),
1,
0
)
)
Then it will work.
Regards,
Lin
hi @dpiechowski
You could just adjust the formula as below:
m.Hide? =
IF (
CALCULATE ( ISFILTERED ( INVENTORY_BIN[DESCR] ), ALLSELECTED ( INVENTORY_BIN ) ),
1,
IF (
CALCULATE ( ISFILTERED ( BIN_LIST[Zone/Tower] ), ALLSELECTED ( BIN_LIST ) ),
1,
0
)
)
Then it will work.
Regards,
Lin
This works beautifully. Thanks
@dpiechowski , see if you can use it using the bookmark
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
I think I figured it out.
It seems like if the ISFILTERED measure is checking any of the columns that are in the table it doesn't work.
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |