Forum Discussion
Select columns according to slicer value
Hi Team,
I have 2 tables
| Employee | Year |
| Abc | 2020 |
| Employee | Country | TotalSales_Compliance | TotalSales_NonCompliance | TotalSales_Compliance_Year | TotalSales_NonCompliance_Year |
| Abc | US | 2000$ | 1000$ | 500$ | 200$ |
In the Report, I have a Year Slicer and table visual which shows:
| Country | Compliance Sales | Non Compliance Sales |
| US |
Now, Whenever users selects 2020 from slicer it should show TotalSales_Compliance_Year and TotalSales_NonCompliance_Year. If user does not select anytihng then it should show me TotalSales_Compliance and TotalSales_NonCompliance in the above 2 columns.
How can i acheive this in Dax ?
Thanks,
Shubham
Anonymous try something like this:
Compliance Sales = IF ( HASONEFILTER ( Table[Year] ), SUM ( Table2[Compliance Year] ), SUM ( Table2[Compliance Total] ) ) Non Compliance Sales = IF ( HASONEFILTER ( Table[Year] ), SUM ( Table2[Non Compliance Year] ), SUM ( Table2[Non Compliance Total] ) )Change table and column name as per your model.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
4 Replies
- parry2k
Super User
Anonymous try something like this:
Compliance Sales = IF ( HASONEFILTER ( Table[Year] ), SUM ( Table2[Compliance Year] ), SUM ( Table2[Compliance Total] ) ) Non Compliance Sales = IF ( HASONEFILTER ( Table[Year] ), SUM ( Table2[Non Compliance Year] ), SUM ( Table2[Non Compliance Total] ) )Change table and column name as per your model.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- parry2k
Anonymous Yes, you can use any one of those. Good to hear it worked out.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- v-robertq-msft
Community Support
Hi, Anonymous
Glad to hear that you have solved your problem, would you like to mark parry2k’s reply as a solution so that others can learn from it too?
Thanks in advance!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
