Forum Discussion
Helper IUse an IF on a column containing string value that if it returns true, returns a number
Helper IHi Samarth_18 upon further investigation, I realised this is not quite the solution as it does not return the true value for me, essentially what I have is set it to 0 and then I have formatted a button so that if the measure is 0, to colour the button green yet it is leaving the colour blank and when I set 0 as the false expression also, it then colours the button, I do not think it is reading the max correctly, I am unsure though
Community ChampionChrisMcHugh you could break down the measure and return the required value, to check if we are getting expected values or not. or you could share your PBIX file after removing sensitive data.
- ChrisMcHugh
Hi Samarth_18 Yes I have broken down the measure and only set one condition on it in an attempt to return the desired outcome but no luck as of yet
- v-easonf-msft
Community Support
Hi, ChrisMcHugh
If the problem persists, please provide your demo for further research.
Best Regards,
Community Support Team _ Eason
