Forum Discussion
dynamic parameter
Hi,
I have a datasource like this:
I need to have a table like this
I need to have a parameter to choose if I want to see only actual or aactual+prevision1 or actual+prevision 2 or actual+prevision 3 based on what I choose on parameter, how can I do?
thanks
Hi Giada90 ,
Ritaf1983 , thanks for your concern about this case.
I made an attempt based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:
1. Using the original data:
2. Create four measures which meet your requirements:actual = SUM('Table'[actual]) Actual+Prevision1 = SUM('Table'[actual]) + SUM('Table'[prevision 1]) Actual+Prevision2 = SUM('Table'[actual]) + SUM('Table'[prevision 2]) Actual+Prevision3 = SUM('Table'[actual]) + SUM('Table'[prevision 3])3. Create field parameters:
4. Using parameters as values for the matrix.
5.The result is as follows:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
6 Replies
Hi
This is a classic scenario for field parameters.
Please refer to the linked video:
https://www.youtube.com/watch?v=V6WchPDZibI&t=4s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Giada90 ,
Ritaf1983 , thanks for your concern about this case.
I made an attempt based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:
1. Using the original data:
2. Create four measures which meet your requirements:actual = SUM('Table'[actual]) Actual+Prevision1 = SUM('Table'[actual]) + SUM('Table'[prevision 1]) Actual+Prevision2 = SUM('Table'[actual]) + SUM('Table'[prevision 2]) Actual+Prevision3 = SUM('Table'[actual]) + SUM('Table'[prevision 3])3. Create field parameters:
4. Using parameters as values for the matrix.
5.The result is as follows:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!thanks!
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
person type actual prevision a sales 5 3 a cost 7 4
what I need to do with parameter and dax (not pivot)
person sales a 5 (or 5+3 it depends from parameter
