Forum Discussion
One Parameter to control multiple columns
Hello,
I need help, on how to create a field parameters like for Total and Average of multiple measures.
Say, when I choose "Total" Parameter it will sum up the column 1, column 2 and so on. And if choose "Average" it will calcu
Hi mee825 ,
Please try below steps:
1. below is my test table
Table:
2. create measure with below dax formula
Total = SUMX('Table',[Column1]+[Column2])Average = DIVIDE([Total],2*COUNTROWS('Table'))3. create a field parameters with meaure
4. add a card visual with parameters
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi mee825 ,
Please try below steps:
1. below is my test table
Table:
2. create measure with below dax formula
Total = SUMX('Table',[Column1]+[Column2])Average = DIVIDE([Total],2*COUNTROWS('Table'))3. create a field parameters with meaure
4. add a card visual with parameters
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly