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.
I thought this would be easy but it isn´t 😉
I want to build a measure showing the month to date sales of the current month.
The measure should ignore all filters that a user sets.
So today the measure should show the sales from Sep 1 to Sep 21 - no matter whatever the user does.
My approach was to combine TOTALMTD and ALL in a meaningful way, but it doesn't work.
This is what I have been trying to do: (AllSales is a measure)
SalesMTD =
TOTALMTD (
[AllSales],
ALL('MyCalendar'[Date]),
MONTH ( 'MyCalendar'[Date] ) = MONTH ( TODAY () )
)
The result is always blank.
I tried a couple of more things but without success.
Can anybody help?
Solved! Go to Solution.
I found a solution myself 🙂
It takes two steps now and maybe there is a (much) easier way.
First step:
SalesMTD =
CALCULATE (
[AllSales],
DATESMTD ( 'MyCalendar'[Date] )
)
Second step:
TodaysSalesMTD =
CALCULATE (
[SalesMTD],
'MyCalendar'[Date]
= TODAY ()
)
The value I show now on the card-visual is TodaysSalesMTD.
Hi @cosmicyes ,
Does that make sense? If so, kindly mark your answer as the solution to close the case please. Thanks in advance.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I found a solution myself 🙂
It takes two steps now and maybe there is a (much) easier way.
First step:
SalesMTD =
CALCULATE (
[AllSales],
DATESMTD ( 'MyCalendar'[Date] )
)
Second step:
TodaysSalesMTD =
CALCULATE (
[SalesMTD],
'MyCalendar'[Date]
= TODAY ()
)
The value I show now on the card-visual is TodaysSalesMTD.
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 |
---|---|
107 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
104 | |
80 | |
66 |