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.
Hi,
I need to generate a list of customers who have placed more orders than the 90% percentile. The list needs to respond to filters on time, product, segment and shop.
Solved! Go to Solution.
Hi @sturlaws ,
Current power bi not support to create dynamic calculated column/table based on filter/slicer.
It is possible to create dynamic measure show dynamic result based on current row contents and filter effects, but if you use it in calculate column.
Row contents will fix to whole table and calculation result not dynamic change by filter/slicer.
Regards,
Xaoxin Sheng
I didn't try the M script on this page myself, but see if it helps -
Regards
Hi @sturlaws ,
Current power bi not support to create dynamic calculated column/table based on filter/slicer.
It is possible to create dynamic measure show dynamic result based on current row contents and filter effects, but if you use it in calculate column.
Row contents will fix to whole table and calculation result not dynamic change by filter/slicer.
Regards,
Xaoxin Sheng
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |