One value as a percent of another

[Anonymous]

Hi! 

I have two DAX formulas:

Overdue AR = 
 CALCULATE(
 SUM(HFM[0-90]), 
 FILTER(HFM,HFM[Helper]=MAX(HFM[Helper])))

AR Trade = 
 CALCULATE(
 SUM(HFM[11100]), 
 FILTER(HFM,HFM[Period]=MAX(HFM[Period])
 ))

Result of the first one is 3, the result of the other one is 25.

I want to create a measure that will show me the percentage of Overdue AR as a total of AR Trade. I have below - as simple as possible, but for some reason, it is not working well (showing 11% instead of 6.5%).

Overdue % = DIVIDE(HFM[Overdue AR],HFM[AR Trade])

Any idea what is wrong?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

---

Result of the first one is 3, the result of the other one is 25.

I want to create a measure that will show me the percentage of Overdue AR as a total of AR Trade. I have below - as simple as possible, but for some reason, it is not working well (showing 11% instead of 6.5%).

---

How to get the result of 6.5%? It looks like calculating "the percentage of Overdue AR as a total of AR Trade. " returns 3/25=12%. Please illustrate your scenarion with sample data and desired output. How to Get Your Question Answered Quickly

Best regards,

Yuliana Gu

[Anonymous]

Of course, you are right, I feel so embarrassed! I need to go back to Primary school and take some mathematics classes...

Regarding your link - this is helpful, I will follow this advice. Thanks a lot! 

[Anonymous]

Hi,

Do you try this formula?

Overdue % = DIVIDE(HFM[Overdue AR],CALCULATE(SUM(HFM[AR Trade]); ALL([AR Trade]))

You need to divide for all, correct?