Text column to create DAX formula or refer to KPI measure

[nebulus]

My scenario:

• line visual shows KPI value per month
• filter selection to choose KPI to be shown in above visual
• one table contains all the KPIs that can be selected from above filter
• I have over 40 KPIs to choose

Do I add one additional column for DAX formulas to be used when KPI is selected or create each KPI as indivudual DAX formula?

How do I refer these in DAX formula?

Example:

I choose to show "Sales" on my line visual. I think that the simplest way is to use sum(Sales) KPI and refer to this in IF() or SWITCH() clause.

value = if ( selectedvalue ( KPI ) = "Sales" , [Sales] , null)

But how this changes if I have another column that says which KPI to use or it says what DAX to use?

[amitchandak]

@nebulus ,  Are you looking to change measure based in slicer value ?

example 

value = Switch( selectedvalue ( KPI ) ,

"Sales" , [Sales]

"COGS" , [COGS]

, blank())

use blank() in place of null, in you, if, if that is the only change you need

refer if needed

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[nebulus]

Thank you for your answer @amitchandak 

This solution is the same as I described on my post. My problem is that I have over 40 measures and there will be more in the future.

I have following table that I would like to use:

KPI	DAX expression	Measure name
Sales	sum(Sales)	[Sales]
COGS	sum(COGS)	[COGS]

value = min ( DAX expression )

or

value = min ( Measure name )

Is there a way to convert text to DAX expression of to refer to created measure?