Switch formula

Question

I'm using a matrix table and switch formula

The switch formula is creating eg 3 columns in the matrix - cost per click, cost per registration and cost per site visit

Is it possible to only show columns where the value > 0?

amitchandak · Answer

Can you share sample data and sample output? If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

anonymous · Answer

HI&nbsp;Anonymousl,
Switch function not suitable to compare with multiple columns it will return the first case if multiple conditions meet for your requirement. In addition, how did you handle them when multiple columns contain values than great than zero?
Regards,
Xiaoxin Sheng

Forum Discussion

Switch formula

2 Replies

Related content

DAX formula SWITCH

If formula

formula

DAX Formula Help

Alternative to SWITCH ()?