Forum Discussion

lucamilanesi's avatar
lucamilanesi
Frequent Visitor
6 years ago
Solved

Using a text measure as a legend

Hello everyone,   I'd need your help: I created the measure "Measure_Level_Asset".    Misura_Livello_Asset = IF(GOV_Asset[Misura_Rischio_Residuo_Asset]<1,"Azzurro",IF(GOV_Asset[Misura_Rischio...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi lucamilanesi

     

    You cannot create calculated column based on measures.This process may be a little complicated, but it can solve your problem.
    1. Create a table with "Azzurro", "Verde", "arancione", "Rosso",Then you can use this column in the legend fields.
    2.Create four separately measures for “ Azzurro” and “ Verde” and “ Arancione” and “ Rosso”. Add these two measures into Values section of the chart.
    DAX is like this:

     

     

    num_Azzurro = COUNTROWS(
		FILTER(ALL('GOV_Asset'),
			[Misura_Livello_Asset] = "Azzurro"
		)
	      )

num_selection = 
    var _nv = SELECTEDVALUE('Table'[Column1])
    return SWITCH(_nv,"Azzurro",[num_Azzurro])

    You can refer to this .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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi lucamilanesi

 

You cannot create calculated column based on measures.This process may be a little complicated, but it can solve your problem.
1. Create a table with "Azzurro", "Verde", "arancione", "Rosso",Then you can use this column in the legend fields.
2.Create four separately measures for “ Azzurro” and “ Verde” and “ Arancione” and “ Rosso”. Add these two measures into Values section of the chart.
DAX is like this:

 

 

num_Azzurro = COUNTROWS(
		FILTER(ALL('GOV_Asset'),
			[Misura_Livello_Asset] = "Azzurro"
		)
	      )

num_selection = 
    var _nv = SELECTEDVALUE('Table'[Column1])
    return SWITCH(_nv,"Azzurro",[num_Azzurro])

You can refer to this .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.

lucamilanesi's avatar
lucamilanesi
Frequent Visitor
6 years ago

Hi V-lianl-msft ,

 

i think that we are not understanding each other or I am really far from understanding the solution (probably) 🙂

I created a dynamic report (by dynamic I mean that varying one or more parameters set get different results and then different views) to simulate different scenarios. Everything is built through calculated columns and measures referred to the parameters.

It works everything except the change of color in the display that I attach, I have to use the calculated field "Level_Asset" (which does not change to vary parameters, of course it is static in the simulation) as a legend and not the measure "Measure_Level_Asset" because of course the measure can not be entered as a legend for various reasons.

So how to do it? 🙂

Thank you very much