DAX for dividing 2 calculated fields from 2 different tables

[skoza12]

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!!!!

[technolog]

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] )

[skoza12]

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.  

[technolog]

You can try 

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

or

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

[skoza12]

Let me give this a try - Thanks

[technolog]

Send a screenshots if it wouldn't work.

[skoza12]

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%

[technolog · Accepted solution]

In this case try use 

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