Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
Hi @Snowy34 ,
If I understand you correctly, please use Unpivot function in Query Editor.
Here’s my sample data:
Please check following steps as below and see if the result achieve your expectation:
1. Unpivot table and apply change:
Result would be shown as below:
2. Create measure:
Measure = DISTINCTCOUNT('Table (2)'[No])
3. Create slicer to filter data:
Hopefully works for you.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good day @v-jayw-msft
The issue with that suggestion is my the data on that table is generated using the below column so it doesn't show up in the queries editor.
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