Forum Discussion

zenton's avatar
zenton
Helper II
4 years ago
Solved

Adding two measures

Hi, I am having issues with slicers and measures. I need two separate results using slicers. and then finally add the results together Selection 1  =  Average of results with Date range selection a...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, zenton ;

    If you want to calculate two measures form two different slicer status, you need to create another table as secondly slicer. as follows:

    1.create a table .

    Slicer2 = SUMMARIZE('Table',[Date],[Point])

    2.create measure1、measure2 and sum.

    Measure1 = CALCULATE (AVERAGE ('Table'[Value] ),FILTER (ALLSELECTED('Table' ), [Name] = "solids" ))
    Measure2 = CALCULATE(AVERAGE('Table'[Value]),FILTER(ALL('Table'),[Point]=MAX('Slicer2'[Point])&&[Date]<=MAX('Slicer2'[Date])&&[Date]>=MIN('Slicer2'[Date]) ))
    Measure = [Measure1]+[Measure2]

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, zenton ;

If you want to calculate two measures form two different slicer status, you need to create another table as secondly slicer. as follows:

1.create a table .

Slicer2 = SUMMARIZE('Table',[Date],[Point])

2.create measure1、measure2 and sum.

Measure1 = CALCULATE (AVERAGE ('Table'[Value] ),FILTER (ALLSELECTED('Table' ), [Name] = "solids" ))
Measure2 = CALCULATE(AVERAGE('Table'[Value]),FILTER(ALL('Table'),[Point]=MAX('Slicer2'[Point])&&[Date]<=MAX('Slicer2'[Date])&&[Date]>=MIN('Slicer2'[Date]) ))
Measure = [Measure1]+[Measure2]

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.