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.
Hi everyone!
I have a static date filter in one measure.
For ecample: Today() -1.
But I need that this filter, Today()-1, calculate about selction date.
I need this, because some measures are specific to that date and others are accumulated until that date.
In summary, I need a variable / measure associated with the user's date selection.
Solved! Go to Solution.
Hi @gabrielvigo,
Try these formulas below.
Test = CALCULATE ( SUM ( Supply_Chain[Operations Stockouts] ); FILTER ( ALL ( 'Calendar'[Fecha] ); 'Calendar'[Fecha] = SELECTEDVALUE ( 'Calendar'[Fecha] ) ) )
Test2 = CALCULATE ( SUM ( Supply_Chain[Operations Stockouts] ); FILTER ( ALL ( 'Calendar'[Fecha] ); 'Calendar'[Fecha] <= SELECTEDVALUE ( 'Calendar'[Fecha] ) ) )
Best Regards,
Dale
So typically you do this with a slicer and something like MAX or SELECTEDVALUE. "What If" measures were created for this purpose.
Hi.
No, I can't calculate them.
I need 2 calculations:
Hi @gabrielvigo,
Try these formulas below.
Test = CALCULATE ( SUM ( Supply_Chain[Operations Stockouts] ); FILTER ( ALL ( 'Calendar'[Fecha] ); 'Calendar'[Fecha] = SELECTEDVALUE ( 'Calendar'[Fecha] ) ) )
Test2 = CALCULATE ( SUM ( Supply_Chain[Operations Stockouts] ); FILTER ( ALL ( 'Calendar'[Fecha] ); 'Calendar'[Fecha] <= SELECTEDVALUE ( 'Calendar'[Fecha] ) ) )
Best Regards,
Dale
User | Count |
---|---|
94 | |
89 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |