Select columns according to slicer value

[Anonymous]

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

[v-robertq-msft]

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.

[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.⚡

[Anonymous]

Thanks. It worked with ISFiltered condition. 

[parry2k · Accepted solution]

@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.⚡