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,
I run into a problem ...
First, there is a Dimension-Table that holds some categories, e.g. A, B, C
With a slicer-visuals the user can select some of them.
There exists a relation to a Fact-table. In the Fact-table is a column with the same categories and the user selects part of the fact table using the slicer. All works pretty fine.
The new request and my problem:
New data are stored in the fact table and it could happen that the new data have some invalid categories (e.g. X,Y, ...)
The customer wants that these illegal entries are always displayed in the very same table visual, regardless what is selected in the slicer.
Example: The slicer is set to category "A", so in the table visual the user wants to see all entries that have category "A" and all entries with illegal categories (other than "A", "B", "C").
How to do this?
Any help is apprecited!
Solved! Go to Solution.
@JohannTTG , Better to keep the category as an independent table and try like
new measure =
var _sel = allselected(category[category])
var _sel1 = allselected(Table[category])
Var _sel2 = union(_sel, except(_sel1,_sel))
return
calculate(sum(Table[value]), filter(Table, Table[category] in _sel2))
////////
with join
new measure =
var _sel = allselected(category[category])
var _sel1 = all(Table[category])
Var _sel2 = union(_sel, except(_sel1,_sel))
return
calculate(sum(Table[value]), filter(Table, Table[category] in _sel2),all(category[category]))
Bingo - that helps, thank you!
@JohannTTG , Better to keep the category as an independent table and try like
new measure =
var _sel = allselected(category[category])
var _sel1 = allselected(Table[category])
Var _sel2 = union(_sel, except(_sel1,_sel))
return
calculate(sum(Table[value]), filter(Table, Table[category] in _sel2))
////////
with join
new measure =
var _sel = allselected(category[category])
var _sel1 = all(Table[category])
Var _sel2 = union(_sel, except(_sel1,_sel))
return
calculate(sum(Table[value]), filter(Table, Table[category] in _sel2),all(category[category]))
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |