Hello there 🙂
I am working on a Power BI Report.
I created a feature layer and am connecting it to the Power BI Dataset with a key that results in an n:n conntection (probably not optimal but haven't found a different solution yet).
I want to add a tooltip to the map visual that calculates a Sum of the Deliveries that were made to that destination. It should also be dynamic. So if I add a slicer on the report page it should show the sum of deliveries from the sliced data.
But no matter what I do, it always just takes the sum of the first selected value from the key.
I tried using measure to hard-code the slicers. I tried joining with the "aggregate" function instead of the "select first row only".
It is hard to exlain but here is an example.
The destination x has 3key that connect the Power BI Data to the feature layer:
| Destination | Key | Deliveries |
| x | 2025_2_3 | 15 |
| x | 2025_2_5 | 10 |
| x | 2025_5_10 | 5 |
When I hover Destination x on the map I would like to see Deliveries = 30
But it just shows the first row: deliveries = 15
Does anybody know it this ist possible?
Best wishes 🙂
