Multiple columns in slicer

Hi Anonymous ,

Based on your description, measure can achieve similar requirment, but column cannot.

Create multiple measures, create a disconnected table with the name of measure, and change measure dynamically through slicer.

Sum_sales = SUM('Table'[Sales])

Rate = 
var total_month_sales = CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[Month name],'Table'[Date].[Year]))
var per_product = [Sum_sales]
return DIVIDE(per_product,total_month_sales)

Measure = SWITCH(SELECTEDVALUE('Table (2)'[slicer]),
            "Rate",[Rate],
            "Sum_sales",[Sum_sales])

Here is the sample .pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.