Forum Discussion
DAX Measure to perform two separate functions based on value
So I have a column called [Audit Item] which contains different values. If the value = [Patient Name] or [Person To Pay"] then I want the measure to result in 0.0% If the value is anything else but...
hi, Anonymous
You could use Format Function to change the format of the result.
https://docs.microsoft.com/en-us/dax/format-function-dax
https://docs.microsoft.com/en-us/dax/custom-numeric-formats-for-the-format-function
If it is not your case, please share some data sample and expected output. Do mask sensitive data before uploading.
Best Regards,
Lin
BhaveshPatel
Super User
Super UserHi Anonymous
You can use standard IF function or SWITCH function to achieve the condition check logic.
Please refer to the below blog post for more information.
https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/