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.
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] ) )
Solved! Go to 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
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
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |