Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Tittle

Howdy everyone, I want to create a dynamic title base on the hierarchy and a selected measure. As you can see I have a slicer where I select the measure I wanna show.

The visual I am using is a simple waterfall.

 

  

The measure used in the visual is the following:
Usado/Disponible = IF(SELECTEDVALUE(Slicer_usado_disponible[Categoria])="Usado",[Usado],[Disponible])
 
also the measures that are being referenced are the following. They both are pretty simple
  • Usado = SUMX(FILTER(Capex_DB,Capex_DB[Categoria]="USADO"),Capex_DB[Value])
  • Disponible = SUMX(FILTER(Capex_DB,Capex_DB[Categoria]="Disponible"),Capex_DB[Value]) 
 Also my visual have 4 fields in the category sectiong as follow so that I can change from one to another.
 

 

I want to create a dax formula that take the Field I am currently in and concatenate with "Disponible" or "Usado". Depends on which on is selected.

 

Expected title would like: "Monto Disponible by Vicepresidencia" or "Monto Usado by Sociedad" 

 

So far I just came up with the following dax formula but I am still clueless regarding how to retrieve the "Category" I am in. 

 

Title Usado/Disponible = "Monto " & SELECTEDVALUE(Slicer_usado_disponible[Categoria])

 

 

 

 

 

 

 

 

 

 

 

Need Help