Forum Discussion

mee825's avatar
mee825
Frequent Visitor
3 years ago
Solved

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. ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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