Forum Discussion

srtamrakar's avatar
srtamrakar
New Member
8 years ago
Solved

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's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity 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