Adding two measures

[zenton]

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 and Point selection

Selection 2  = Average of results with Date range selection and Point selection

I need to associate slicers Point 1 and Date 1 with Measure 1 and Point 2 and Date 2 with Measure 2. Then finally add the two slicers results together

One Table with the following columns -  Date, Point, Name, and Value

Slicers
Point 1 = Point (example "AA")
Date 1 = Dates between, Date (example 1/7/2020 to 30/6/2021)

Point 2 = Point (example "BB")
Date 2 = Dates between, Date (example 1/10/2020 to 30/4/2021)

Measure 1 =
CALCULATE (
    AVERAGE ( Table[Calculated Value] ),
    FILTER ( Table, Table[Name] = "solids" ),
    ALLSELECTED ( Table[Point], Table[Date] )
)

Measure 2 =
CALCULATE (
    AVERAGE ( Table[Calculated Value] ),
    FILTER ( Table, Table[Name] = "solids" ),
    ALLSELECTED ( Table[Point], Table[Date] )
)

Measure 3 =

Measure 1 + Measure 2 (example 580 + 240 = 820)

I can use Edit interactions for individual results but can add them together

Thanks, Rodney

[v-yalanwu-msft · Accepted solution]

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.

[amitchandak]

@zenton , I have video on similar topic, see if that can help

How to use two Date/Period slicers:https://www.youtube.com/watch?v=WSeZr_-MiTg

or

 Comparing Data Across Date Ranges