Forum Discussion
srtamrakar
8 years agoNew Member
Summarize as a Measure
Hello everyone!
I would like to generate a dynamic table relatedParts by filtering out information which is selected by the user on a slicer.
Could anyone please help me with this?
partOptions = DISTINCT(vehicle[part_exchanged])
selectedPart = SELECTEDVALUE( partOptions[part_exchanged], "A")
relatedParts =
SUMMARIZE (
FILTER ( vehicle, ( vehicle[vehicle_id] in CALCULATETABLE(DISTINCT(vehicle[vehicle_id]), FILTER(vehicle, vehicle[part_exchanged] = [selectedPart]))
&& vehicle[part_exchanged] <> [selectedPart] ) ),
vehicle[part_exchanged],
"count", COUNT ( vehicle[vehicle_id] )
)Hi srtamrakar,
Firstly, power bi doesn't support dynamic calculate column or dynamic calculate table. In addion, you can create a measure using pattern: calculate(..., filter()), then drag the measure to your chart.
Regards,
Jimmy Tao
1 Reply
- v-yuta-msft
Community Support
Hi srtamrakar,
Firstly, power bi doesn't support dynamic calculate column or dynamic calculate table. In addion, you can create a measure using pattern: calculate(..., filter()), then drag the measure to your chart.
Regards,
Jimmy Tao