New to power bi / Simle dax

[DennisSchlein]

Hi 

Ive been trying for hours now to find the right way. But I can't.

I want to calclulate the share of parcels delivered on time.

I have a table, where the count of rows is my total.

Ex.:
ParcelNumber - CompletionDiffDays
12456               -             1
11123               -             0
13246               -             0



Co I want to count rows/ParcelNumber as total. Then all rows <0 = On time, the rest is delayed.

So this example would be 3 total, 1 delayed, 1 on time. So I want a card to display 66,6% on time.

But how to write the calculation?

[DennisSchlein · Accepted solution]

I found out:

On time deliveries = (CALCULATE( COUNTROWS( 'Fact' ), FILTER( ALL('Fact'), 'Fact'[CompletionDiff] <= 0 ))/CALCULATE(COUNTROWS('Fact')))

[truptis]

Hi @DennisSchlein , 

Your requirement is not very clear, especially the formula. Could you please give a proper example? 

[DennisSchlein]

Hi 
I have made this simple sample dataset.

So I want to count destinct tracking number - as total.
In this case, 28. Then all the parcel numbers with a CompletionDiff less or equal to 0 is on time.
So the on time share of the total? (sorry for the picture. I cannot figure how to insert two coloumns from excel and format it correctly. 

Kind regards

[DennisSchlein]

Was thinking something like this could have worked, but it doen't:

TotalShare = CALCULATE(DISTINCTCOUNT('Fact'[CompletionDiff]), 'Fact'[CompletionDiff] <= 0) / CALCULATE(COUNTROWS('Fact') )