Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |