topic Re: Multiple VAR formulas in same measure in DAX Commands and Tips

Multiple VAR formulas in same measure

charliec — Fri, 10 Jul 2020 11:13:50 GMT

Hi there how are you? My name is Carlotta and I am a heavy Power BI user for my work.
I am not sure if this is the right place to address my question, but I will try anyway 😊
I am facing an issue trying to have multiple variables in the same Measure, is it something that is doable at all?

This is the measure i have but i want to split the result "To Be Confirmed" in 2 other results based on different datails

Is it at all possible?

Thanks in advance for your suggestions!

Re: Multiple VAR formulas in same measure

AntrikshSharma — Fri, 10 Jul 2020 12:47:56 GMT

You can have as many variables you want, also you should use SWITCH instead of IF

Re: Multiple VAR formulas in same measure

amitchandak — Fri, 10 Jul 2020 15:40:48 GMT

charliec , use switch true

Shipment Category =
switch( true(),
'Shipped'[order sum ] <= 40000,"Quick Ship",
'Shipped'[order sum ] < 100000,"10 Day",
"30 Day"
)

Re: Multiple VAR formulas in same measure

Anonymous — Fri, 10 Jul 2020 16:19:19 GMT

HI charliec ,

Shorter version of your code.

You cannow use SWITCH()

Delivery Status = VAR DDU = 'F20 SO TO PO'[Delayed Days Updated] VAR f = 'F20 SO TO PO'[EPO Status] VAR r = 'F20 SO TO PO'[ReservationStatus] RETURN SWITCH ( TRUE (), f = "Shortage", "Shortage/Released", f = "To Be Confirmed", "To Be Confirmed", r = "Reserved Physical", "0. In BKM", DDU > 30, "5. Very Late (30+)", DDU > 14 && DDU <= 30, "4, Late (15-30)", DDU > 7 && DDU <= 14, "3, Late (8-14)", DDU > 0 && DDU <= 7, "2. Late (1-7)", DDU <= 0, "1. On Time", "Error" )

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!