topic Re: DAX for dividing 2 calculated fields from 2 different tables in DAX Commands and Tips

DAX for dividing 2 calculated fields from 2 different tables

skoza12 — Wed, 20 Jul 2022 16:20:26 GMT

Hi - I am new to Power BI and I am trying to duplicate a report from another application that we use which shows the percent of service calls by catagory in relation to total service calls. In this example I have 195 total service calls and 7 of them are no problem found. I would like to present this as a percentage. Thanks for any help!!!!

Re: DAX for dividing 2 calculated fields from 2 different tables

technolog — Wed, 20 Jul 2022 18:15:31 GMT

Hi!

You can create first measure:

All calls = COUNTROWS('Table calls')

and second measure:

Non fault calls = CALCULATE( [All calls] , 'Table calls'[Action code] = "Tested and returned ....**USE YOU TITLE* " )

and result measure:

Percent of fault = DIVIDE ( [Non fault calls] , [All calls] )

Re: DAX for dividing 2 calculated fields from 2 different tables

skoza12 — Thu, 21 Jul 2022 13:02:00 GMT

HI,

Thank you for a quick response and after a couple of attempts I understand the logic but I am still not outputing the correct data for the first measure. (may be a filtering issue). I show 204 service calls in the table but when I create the first measure the output is 1480.

Re: DAX for dividing 2 calculated fields from 2 different tables

technolog — Thu, 21 Jul 2022 13:39:08 GMT

You can try

All calls = COUNT('Table calls'[WONumber])

All calls = DISTINCTCOUNT('Table calls'[WONumber])

Re: DAX for dividing 2 calculated fields from 2 different tables

skoza12 — Thu, 21 Jul 2022 14:54:16 GMT

Let me give this a try - Thanks

Re: DAX for dividing 2 calculated fields from 2 different tables

technolog — Thu, 21 Jul 2022 15:12:43 GMT

Send a screenshots if it wouldn't work.

Re: DAX for dividing 2 calculated fields from 2 different tables

skoza12 — Mon, 25 Jul 2022 14:27:23 GMT

I have tried your suggestion and i am almost there.

My first measure

Measure 2

Measure 3

Measrure 1 result = 237

Measure 2 result = 11

Measure 3 result should be 11/237 = 4.64% but is being calcuated as 5.85%

Re: DAX for dividing 2 calculated fields from 2 different tables

technolog — Mon, 25 Jul 2022 18:40:36 GMT

In this case try use

Measure 3 = DIVIDE ( [Measure 2] , [Measure 1] )