Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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] )
)
Solved! Go to 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.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |