topic Re: VAR measure to get the ratio in DAX Commands and Tips

VAR measure to get the ratio

Trooz — Thu, 23 Apr 2020 23:59:11 GMT

Hello All,

I'm writing this to seek your assistance to help me understand how this measure can be performed 🙂

Please check the the images and adivse how can I get this result. (I didn't find VAR in the DAX suggestions but I found other types of VAR+s/p ect.,)

Many thanks 🙂

Re: VAR measure to get the ratio

vivran22 — Fri, 24 Apr 2020 02:28:28 GMT

Hello Trooz ,

Is your objective is to understand how the DAX measure you have posted is working and why you can't find VAR in the DAX intellisense list? Please confirm.

You will not get VAR in the DAX intellisense list. The common syntax is:

[Measure Name/Calculated Column Name] =

VAR [VariableName1] = Expression1

VAR [VariableName2] = Expression2

RETURN

Expression3

VAR.P and VAR.S is formula for calculating variance of population and sample respectively.

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

Re: VAR measure to get the ratio

Anonymous — Fri, 24 Apr 2020 12:15:27 GMT

"I'm writing this to seek your assistance to help me understand how this measure can be performed"

This measure... WHICH MEASURE? I'm trying to guess from the pictures... The only sensible guess would be you want a measure that will show the ratio of all currently visible purchases to 4-legged animals. If this IS the case, then:

[Total Quantity] = SUM( Purchase[Quantity] ) [FourLeggedRatio] = var __4leggedQty = CALCULATE( [Total Quantity], 'Product'[Legs] = 4 ) var __totalQty = [Total Quantity] var __ratio = DIVIDE( __totalQty, __4leggedQty ) return __ratio

Is this what you wanted?

Best

Re: VAR measure to get the ratio

Trooz — Fri, 24 Apr 2020 15:21:57 GMT

vivran22 hi Vivran

thank you for your reply 🙂 , yes I want to apply the same function in power BI, as shown in the images they wrote four commands un the same function/DAX.

You told me that I cannot find "VAR" but in the examole above I don't know how they got it.

Re: VAR measure to get the ratio

Trooz — Fri, 24 Apr 2020 15:37:41 GMT

Thank you Anonymous I appreciate your reply and I'm sorry for not being sufficiently clear.

I just would like to perform the same function shown above in the image in only one step.

I'm unable to write all those functions in the same tab, as you see in the right part of the page "All measures" contains only one measure "FourLeggedRatio" and in the left part you can see that they peformed four comands in only one measure.

Re: VAR measure to get the ratio

vivran22 — Sat, 25 Apr 2020 02:54:35 GMT

Trooz

When I said that you cannot find VAR in PBI, I meant you will not get it in the intellisence suggestions. VAR is a short form of Variable, which stores the result of an expression.

You may find following articles helpful:

https://docs.microsoft.com/en-us/dax/var-dax

https://blog.enterprisedna.co/using-variables-in-dax-a-detailed-example/

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn