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've been trying to figure out how to approach this situation. I have a table like the one here:
I need a measure (Measure) that calculates the sum of TD based on the MidPoint Column refereferenced by EndPoint Column. So, if I choose EndPoint = Point A it sould return 8 as the sum of 4+3+1 where Midpoint = EndPoint = Point A. The problem is that when I select (filter) EndPoint = Point A, it filters out the rows where MidPoint = Point A, so what I get is 0.
Please help with this.
@amitchandak @Ashish_Mathur @ray_ux
Thank you!
Hi,
In the Query Editor, select te last 2 columns, right click and select Unpivot Other columns. Create a slicer of Attribute and select Midpoint. Create another slicer of Value and select Point A. Write this measure
Measure = sum(Data[TD])
Hope this helps.
@mvelasquez1970 , Try a measure like
calculate(sum(Table[TD]), filter(allselected(Table), Table[Mid Point] = max(Table[end Point]) ) )
Thanks,
It partially works. When I use a table it shows the correct result for each EndPoint. However, when I select an EndPoint from a slicer it returns 0...
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |