Forum Discussion
Solved
Lump values not selected in slicer
Hi All, I have a table with "Sales Person Name" column and "Total Sale" and other relevant data, like product, city, etc. I've added a slicer to analyse the performance by "Sales Person Name", ho...
Hi stissot ,
You may try to create measures like DAX below, you can put measure Average Sale into Card visual to as performance benchmark.
Total sale per Sales Person= CALCULATE(SUM(Table1[sale]),FILTER(ALLSELECTED(Table1), Table1[Sales Person Name] =MAX(Table1[Sales Person Name]))) Average Sale= AVERAGE(Table1[sale])
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-xicai
Community Support
Community SupportHi stissot ,
You may try to create measures like DAX below, you can put measure Average Sale into Card visual to as performance benchmark.
Total sale per Sales Person= CALCULATE(SUM(Table1[sale]),FILTER(ALLSELECTED(Table1), Table1[Sales Person Name] =MAX(Table1[Sales Person Name]))) Average Sale= AVERAGE(Table1[sale])
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.