Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
[ToolTip Tile] =
SWITCH ( TRUE (),
HASONEFILTER ( Dataset[Category] ),
SELECTEDVALUE (
Dataset[Cateogry],
"Select Category"
),
HASONEFILTER ( Dataset[Location] ),
SELECTEDVALUE (
Dataset[Location],
"Select Location"
),
"No record available"
)
If you want to save time, then you want to carry out calculation inside SWITCH, not outside. SWITCH will often (not always) perform only the needed calculations whereas if you take out the formulas and put them in variables outside SWITCH, all of them will get calculated (unnecessarily most of the time).
Best
D
[ToolTip Tile] =
SWITCH ( TRUE (),
HASONEFILTER ( Dataset[Category] ),
SELECTEDVALUE (
Dataset[Cateogry],
"Select Category"
),
HASONEFILTER ( Dataset[Location] ),
SELECTEDVALUE (
Dataset[Location],
"Select Location"
),
"No record available"
)
If you want to save time, then you want to carry out calculation inside SWITCH, not outside. SWITCH will often (not always) perform only the needed calculations whereas if you take out the formulas and put them in variables outside SWITCH, all of them will get calculated (unnecessarily most of the time).
Best
D
You can remove that IF condition from HASONEFILTER because it already returns TRUE if the column has one filter else it returns FALSE. You can try this construct, let me know if it doesn't work for you.
ToolTip_Tile =
VAR SelectedMainCategory =
HASONEFILTER ( Dataset[ Cateogry] )
VAR SelectedLocation =
HASONEFILTER ( Dataset[Location] )
VAR MainCategory =
SELECTEDVALUE ( Dataset[ Cateogry], "Select Category" )
VAR Location =
SELECTEDVALUE ( Dataset[Location], "Select Location" )
RETURN
SWITCH (
TRUE (),
SelectedMainCategory, MainCategory,
SelectedLocation, Location,
"No record available"
)
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |