Countifs in DAX

MrJoosten

Board Regular
Joined
Nov 12, 2016
Messages
118
Hi Guys,

I have some problems with counting ID's that meet 2 conditions but on a different row. Can someone help me out with a formula? See the table below for example.

Thanks a lot!

ID
IDCondition 1Condition 2If ID meets condition 1 and 2 then return ID, else return blank
1001101001
1001011001
100201
100201
1003111003
 

MrJoosten

Board Regular
Joined
Nov 12, 2016
Messages
118
Edit: even better would be 1 measure to sum distinct-count ID's that meet both conditions.
 

Forum statistics

Threads
1,077,913
Messages
5,337,128
Members
399,128
Latest member
Andre Pires

Some videos you may like

This Week's Hot Topics

Top