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.
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.
User | Count |
---|---|
79 | |
77 | |
70 | |
68 | |
54 |
User | Count |
---|---|
107 | |
99 | |
88 | |
79 | |
67 |