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 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
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.

2 Replies

  • 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.