Forum Discussion

Snowy34's avatar
Snowy34
Helper III
6 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

Snowy34's avatar
Snowy34
Helper III
6 years ago

Thank you Anonymous  for helping I got it working the way i want 🙂