No of Cats per Job

[MikeyB]

Hi, 

If I use the following measure:

Avg Cats per Job = (count(TotalInvoicedByStockCode[InvoiceItemQty]))/TotalInvoicedByStockCode[Total Jobs]

I get the result of 3.0 because only 437 of the 906 jobs have cats.

How do I change the formula to show 1318/906?

Jobs 906
Jobs with a Cat 437
Total No of Cats 1318
Average Cats per job 3.0 (1318/437)

How do I calculate cats per job? 1.45 (1318/906)

Thanks

[Greg_Deckler]

@MikeyB FINALLY!!!! A question about cats!! Unfortunately not sure there is enough information to provide an answer. You might try the following:

Avg Cats per Job = 
  DIVIDE
    COUNT(TotalInvoicedByStockCode[InvoiceItemQty]),
    CALCULATE(TotalInvoicedByStockCode[Total Jobs],ALL('TotalInvoicedByStockCode')),
    0
  )

I am making a lot of wild assumptions. So if this doesn't help, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.