cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

Yes/No Calculated Column or Measure Based on Running Percentage Measure

Hello All,

I want to create a calculated column or measure based on a running percentage measure. A sample file link is attached. The expected result is a column that identifies any vendor that has a value of =< 80% in the running percentage column and assigns a value of "YES" to that vendor in a new column. Any vendor that has a running percentage value of >80% gets assigned a value of "NO".

Thank you for any assistance you can provide!

Michael

3 REPLIES 3
New Member

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 !!

I accept Kudos :-), If you find my post helpful.
Helper I

Hello @bhagyashrip22

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

Community Support

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.

Best Regards,

Community Support Team _Janey