Slicer selected bring a text from an excel

[claraigg]

Hello,

I am troubleshooting to bring a text from an excel file when I choose an Operating Unit. The excel has different texts for each operating unit and my formula is just bringing the first. Is any way?

thank you!

This is my calculation. However, it just bringing the first text, it is not working when I am selecting other operating unit.

comments_iniciative = if(not([SlicerCheck_OU] = 0), calculate(max('comments_iniciatives'[SPECIAL INICIATIVES]), filter('comments_QTR', [yr_qtr] = [max_SP])), " ")

[PhilipTreacy]

Hi @claraigg 

Can't help you without the data/file you are using.  Please supply them.

Phil