Forum Discussion

datboioscarr's avatar
datboioscarr
Frequent Visitor
5 years ago

Replace Text Value on Table based on Conditions

Hello,   Is it possible to dynamically replace values on a table at the row level? I'm currently working on a report that needs to solve the following:   Highlight what access level a user has to...
Need Help
Tips and Tricks
v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, datboioscarr 

 

I created a simple sample

Tables:

To create a measure like this:

 

_Show = 
var _leverID=CALCULATE(MAX('Member'[Level ID]),ALLSELECTED('Member'[Name]))
var _market=CALCULATE(MAX('Access'[Market]),FILTER(Access,'Access'[Level ID]=_leverID))
var _isIn=IF(CONTAINSSTRING(_market,MAX('Data'[Market])),1)
return _isIn

 

Then display value when item is 1 in the filter pane

Result:

Please refer to the attachment below for details. Hope this helps.

If I did not understand your question correctly, please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion.

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.