topic Re: Help with measure divison in DAX Commands and Tips

Help with measure divison

angadarora18 — Tue, 10 May 2022 15:32:31 GMT

Hi all,

I am very new to PowerBI and am looking for some assistance. I am working on a dashboard that was already created so I am unfamiliar with the foundations of it.

I have two visual cards of data (shipment quantity and delivery quantity) and am trying to divide the two to get a percentage value in another visual card, however the division I am doing does not get me a proper value. Any ideas for what I can do? Any help would be much appreciated!

Re: Help with measure divison

tackytechtom — Tue, 10 May 2022 17:25:56 GMT

Hi angadarora18 ,

It is hard to tell what the issue is. You might wanna share some data and screenshots of the error. But I'll give it shot anyway.

If each of the visual is using a measure, I'd write the new "percentage" measure like this:

DivideMeasure = 
DIVIDE ( [Measure1], [Measure2] )

Afterwards you can switch the Format of the measure by clicking on it in the field pane and then under Measure tools you can change the Format to Percentage.

Does this help? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Re: Help with measure divison

v-cazheng-msft — Mon, 16 May 2022 06:37:33 GMT

Hi angadarora18,

Not sure about how your data tables look like and how you count shipment quantity and delivery quantity.

I create some sample data for illustration.

And count by these two measures.

shipment quantity = CALCULATE(COUNT('Table'[Order]),FILTER('Table','Table'[Status]="shipment")) delivery quantity = CALCULATE(COUNT('Table'[Order]),FILTER('Table','Table'[Status]="delivery"))

Then, just take them to do the division.

PercentValue = [shipment quantity]/[delivery quantity]

The result looks like this. And sometimes, you need to take attention to the format of the result, especially for the decimal data, you may need change the numbers of decimal places shown to see the correct result.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know how your tables look like, the relationships you create for them and how you create these two count measures. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun