Forum Discussion
Solved
Better Measure options?
Good afternoon all, I'm using the below measure to get a sum but I'm using the same measure 11 times and I was hoping I could maybe use one to give me the same information... measure 1 1 Da...
Hi Snowy34 ,
Are you want the sum of [222] for each [Warehouse]?
If so, you just need to create a slicer base on [Warehouse] and refer the below measure to modify your measure:
Overall Performance =
VAR a =
CALCULATE (
SUM ( 'Date Table formula'[222] ),
FILTER (
'Date Table formula',
AND (
'Date Table formula'[DayMonthYear] >= 'DOP-055'[Customer Requested Date],
'Date Table formula'[DayMonthYear] <= 'DOP-055'[Depature Date.1] - 1
)
)
)
RETURN
IF ( ISBLANK ( a ), "NA", a )
The result would be shown as below:Hopefully works for you.
Best Regards,
Jay
Good day all,
Here is an example of how the data looks like, in this case I would need two measure and in my case, I have 11