Forum Discussion
Needed Help!!!
Hi all, I have a Requirement Like.. i have a foure Kpis and i ineed to calculate the top20%records and next20%,,,Bottom 20% of each kpi.and after that i need to calculate the min,max,mean, in that t...
hi, Anonymous
First, You should know that
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
here is reference:
https://community.powerbi.com/t5/Desktop/Different-between-calculated-column-and-measure-Using-SUM/t...
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Second, the group is base on the whole table, you could see that the total in the bottom is right.
Please share your sample pbix file and expected output. Do mask sensitive data before uploading.
Best Regards,
Lin
Hi Team,
Please remove the replyed image as soon as posible.