Many times we have the data with a structure that is not the desired one and to show the information as you want is a bit complicated. For this purpose, functions such as SELECTEDVALUE and SWITCH exist in PowerBI to generate dynamic metrics.
An example of this problem for instance, we have many columns for each row. In the report we have to develop we have to show only one column but this column must be able to change depending on the selected filter.
So, to do this with PowerBI it is necessary to make use of DAX to implement the logic and auxiliary tables to display the filters.
Download of material: http://datamanagement.es/Recursos/DAX_Medida_Dinamica.rar
In the structure of the dataset all the metrics in columns are defined. we want to have a column that is conditional and depends on the selected filters.
Pingback: Star schema. The Business Intelligence’s building block - Data Management