Disregard the blanks when of another field when distinctcount

[Applicable88]

Hello,

I use following measure to distinctcount the transportorders

Measure = Calculate ( distinctcount( 'Transporttable'transportorders), 'Transporttable' duration<60 )

Unfortunately it also counts the blank() values in duration liker ordernumber 1234:

Orders		Duration		Count Intervall
1234				1
1235		14		1
1236		12		1
1237		55		1
1238		44		1
1239		33		1
1240		56		1
1241		34		1
1242		22		1
1243		13		1
1244		18		1
1245		888		0
1246		888		0
1247		678		0
1248		545		0

how to disregard the duration with blank field? 

I tried following with no success:

Measure = Calculate ( distinctcount( 'Transporttable'transportorders), 'Transporttable' duration<60 && 'Transporttable' duration<> blank() )

But with that I got a totally different value.

Hope someone knows my mistake.

Thank you very much in advance.

Best. 

[Syndicate_Admin · Accepted solution]

Yes, right.

Measure = 
CALCULATE( 
    Countrows(DISTINCT('Table'[Órdenes])),
    FILTER('Table',
    'Table'[Duración] <> BLANK()
        && 'Table'[Duración] < 60
    )
)

Prove it in this data:

and the value was still 10.

If this post answers your question, please mark as "Accept as a solution" so that other people can also access it.

Best regards

Ivancito

[Applicable88 · Accepted solution]

Solved with an equal problem here:

https://community.powerbi.com/t5/Desktop/Counting-distinct-without-blanks-of-another-field/m-p/22364...

[Syndicate_Admin]

Hello, good afternoon, if I understand correctly, this measure will help you solve your problem.

Measure = 
COUNTROWS(
    FILTER('Table',
    'Table'[Duración] <> BLANK()
        && 'Table'[Duración] < 60
    )
)

This is the result that gave me the account:

If this post answers your question, please mark as "Accept as a solution" so that other people can also access it.

Best regards

Ivancito

[Applicable88]

Hi @Syndicate_Admin thanks so much so far, but is there a way to include counting distinct orders? some can be double sometimes. 

And why  that part doesn't work out?

Measure = Calculate ( distinctcount( 'Transporttable'transportorders), 'Transporttable' duration<60 && 'Transporttable' duration<> blank() )

[Syndicate_Admin · Accepted solution]

Yes, right.

Measure = 
CALCULATE( 
    Countrows(DISTINCT('Table'[Órdenes])),
    FILTER('Table',
    'Table'[Duración] <> BLANK()
        && 'Table'[Duración] < 60
    )
)

Prove it in this data:

and the value was still 10.

If this post answers your question, please mark as "Accept as a solution" so that other people can also access it.

Best regards

Ivancito