Forum Discussion
Helper IYes/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.
Helper IHello 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