Forum Discussion
Yes/No Calculated Column or Measure Based on Running Percentage Measure
Hello MStP ,
Please find the below DAX measure for getting a calculated column which gives output of Yes/No based on your condition:
DAX measure (Yes/No) = IF( [Sales percentage cumulate:] <= 0.8, "YES", "NO")
I hope this helps you.
~ Happy Learning !!
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.
Hello Anonymous
Your solution works. I have a follow-up issue in that when I try to add this measure to a different visual, PBI just spins its wheels.
So here is the visual that contains the running percentage and yes/no for all vendors queried:
When I attempt to add the Yes/No column to a different visual with a much smaller sub-set of vendors (from the same vendor table), PBI just thinks about it for a long time but the visual will not update.
The original vendor list is 1000+ vendors. This second visual contains perhaps 100. Can you tell me why this is happening based on this limited information? Both sets of vendors are from the same table - this table is referenced in the Running Percentage measure, so it seems there is no disconnection.
Thank you for your continued assistance!
Michael
Hi, MStP
The problem is that your measure is nested inside the measure, and you use a function such as allselected, which will cause the value of the measure to change dynamically according to the context.
Obviously, we need an updated sample to judge, we don't know the data in your screenshot.
If you can't give a sample, you can try to combine several measures into one measure, and then judge where the problem is by returning different variables step by step.
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.Best Regards,
Community Support Team _Janey
