Urgent Count of Orders for payment method

[qwaiti27231]

 

order id     amount  payment method

1                   4               4

1                   3               3

1                   2               2

2                   1              2

2                   2              4

3                   2             3

3                   3             1

4                   4             2

4                   7             1

5                   1             1

each order id might have two or more payment method which has separate amounts .we need to know how many orders are  there for each payment method

payment method 1=1(amount in payment method)>3(amount in payment method),1>4(amount in payment method)  amount in payment method should be greater than all payment method in that particular order id

payment method 2=2(amount in payment method)>3(amount in payment method),2(amount in payment method)>4(amount in payment method)

payment method 3=3(amount in payment method)>1(amount in payment method),3(amount in payment method)>2(amount in payment method),3>4

payment method 4=4(amount in payment method)>1(amount in payment method),4(amount in payment method)>2(amount in payment method),4(amount in payment method)>3(amount in payment method)

output

payment Method   Orders(count of order id)

4                             -2 orders

3                             -1 orders

2                             -0 orders

1                             -3 orders

[qwaiti27231]

1                   4               4

1                   3               3

1                   2               2

2                   1              2

2                   2              4

3                   2             3

3                   3             1

4                   4             2

4                   7             1

5                   1             1

each order id might have two or more payment method which has separate amounts .we need to know how many orders are  there for each payment method

payment method 1=1(amount in payment method)>3(amount in payment method),1>4(amount in payment method)  amount in payment method should be greater than all payment method in that particular order id

payment method 2=2(amount in payment method)>3(amount in payment method),2(amount in payment method)>4(amount in payment method)

payment method 3=3(amount in payment method)>1(amount in payment method),3(amount in payment method)>2(amount in payment method),3>4

payment method 4=4(amount in payment method)>1(amount in payment method),4(amount in payment method)>2(amount in payment method),4(amount in payment method)>3(amount in payment method)

output

payment Method   Orders(count of order id)

4                             -2 orders

3                             -1 orders

2                             -0 orders

1                             -3 orders

[Greg_Deckler]

Should just be:

Measure = COUNTROWS(DISTINCT('Table'[order id]))

Put that into a table visual along with [payment method].