Summarize as a Measure

[srtamrakar]

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] )
    )

[v-yuta-msft · Accepted solution]

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