Page 1 of 1

Dynamic Taxt Measure

Posted: Sun Jan 28, 2018 8:58 am
by suebasri
Hi,
Is there any way to make a text measure for the following scenario

1. I have a visual showing several Sales Product

2. I would to be able to make a text measure that shows the name of the sales product each time i click on the different sales product

Example: sales Product = Perfume, Soap, Toothbrush

So far I am successful to get as far as this {change the calender year when i click on the year slicer)

>> = "As at "& 'Measure Calender'[Year1] & " shows "& [VarProd] & " for " & .................

Please help

Thanks
Sue