Hide Column only if it is selected and total in total column

[Anonymous]

Hello Guys!
I am recently doing a project in which i have a requirement from client says that we have 3 companys and in the report the companies column on demand like if we select company 1 then total of company 1 only if we select two 2 companies then only show two companies column and total = Company1 + Company 2

Company 1	Company 2	Company 3	Total Company
100	200	900	1200
200	400	566	1166
300	800	1233	2333

I have done other things but how to hide column if it is not selected ?
please share your advise and solution Thanks in advance
@amitchandak 
@Greg_Deckler 

[Greg_Deckler]

@Anonymous What does your source data look like? If you have Company1, Company2 and Company3 columns then try unpivoting those in Power Query Editor.

[Anonymous]

@Greg_Deckler 
I want to show Company measure when i select company name from slicer else it should be hide.

Company 1 Measure	Company  2 Measure	Company 3 Measure	Total Company	Measure 1	Measure 2	Measure 3	Measure 4
100	200	900	1200
200	400	566	1166
300	800	1233	2333

[Anonymous · Accepted solution]

Hi @Anonymous,

You can add if statement to package your measure expression to add conditions check if slicer selected specific values or they will replace to blank results.

ISFILTERED function (DAX) - DAX | Microsoft Docs

Regards,

Xiaoxin Sheng

[Anonymous]

Actually i have 3 companies and other measures
3 companies should Be there when i select from them single or multiple.