Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |