Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi all,
I have a measure called [no of deliveries] which I normally use with my date table ‘Dim-OutboundDate’
I need to use this measure with my other date table ‘Dim-Date’, and the outcome should be the same.
No matter what I try though, the outcome is different when I group it by week in the visual.
This is the new measure I’m trying to create:
CALCULATE(
[no of deliveries],
TREATAS(
VALUES(
'Dim - Date'[ID_Date]
),
‘Dim-OutboundDate’ [ID_Date]
))
Below is my data model (one to many) and I am restricted to do any physical changes with the relationships, so I need to solve this with a measure.
Many thanks!
Solved! Go to Solution.
Try
My Measure =
CALCULATE (
[no of deliveries],
TREATAS ( VALUES ( 'Dim - Date'[ID_Date] ), 'Dim-OutboundDate'[ID_Date] ),
REMOVEFILTERS ( 'Dim - Date' )
)
Try
My Measure =
CALCULATE (
[no of deliveries],
TREATAS ( VALUES ( 'Dim - Date'[ID_Date] ), 'Dim-OutboundDate'[ID_Date] ),
REMOVEFILTERS ( 'Dim - Date' )
)
It worked! I am really impressed by you sir!
Many thanks!
User | Count |
---|---|
11 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
25 | |
19 | |
16 | |
10 | |
7 |