DYNAMIC MEASURE LABEL PL PIVOT

[eduardoheres]

hi all

im trying to have a dinamyc label measure depending in dimension value, i try with an if but if i dont have the dimension selected i got all nulls. I try with isnull but is the same

how can i get the not selected fields of one dimension

for example im searching the opposite of the function getfieldsselected 

thank you!

[kaushiknsolanki]

Hi,

You can use the Concat(Distinct Field) to get all the possible values separated by comma.

[eduardoheres]

Thank you but now i got currentmonthopenorderstautusytd why can now make a dynamic measure label if = openorderstatus put allocated else put actuals, i already try with and if but i only get null values or the same values for all

[ggijben]

@eduardoheres  i have the same problem. Did you manage to fix this?