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.
Hello,
I've got this table:
Date | Value | |
1/1/22 | 2 | |
1/1/22 | 3 | |
1/1/22 | 5 | |
1/1/22 | 1 | |
2/1/22 | 5 | |
2/1/22 | 3 | |
3/1/22 | 1 |
I use a filter visual to filter >="2/1/22"
I would like to print in a table visual these values, so I need a DAX function that ignores the date in the table but keeps the date from the filter (using ALL() in a calculate makes the measure ignore both the filter and the data column in the table visual):
Date | Sum of Values | Cumulative sum starting from filter date | |
1/1/22 | 11 | ||
2/1/22 | 8 | 8 | |
3/1/22 | 1 | 9 |
Thanks for support!
Solved! Go to Solution.
I found how to solve this using ALLSELECTED() in a MINX() that does exactly what I meant without creating disconnected parameters. Thanks everybody anyway!
You're sort of skirting the generally intended behavior of slicers, so this isn't quite as simple as you might think it ought to be.
To do this, create a new disconnected parameter table for the IDs:
dimID = VALUES(Table1[Id])
Use this new table for your slicer and write a measure that reads these values.
SumNum = CALCULATE ( SUM ( Table1[Num] ), KEEPFILTERS ( Table1[Id] IN VALUES ( dimID[Id] ) ) )
Put this in your table and it should behave as expected provided you set 'Show items with no data' on the Table1[Id] column.
Result:
I found how to solve this using ALLSELECTED() in a MINX() that does exactly what I meant without creating disconnected parameters. Thanks everybody anyway!
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |