DAX formula

[cham]

Hi @dedelman_clng 

id	Driver 1D
10	1
9	1
8	1
10	1
10	2
10	2
10	3
9	3
9	3
8	3
8	3
8	3
8	3
8	1
8	3
8	3
8	1
7	4
7	4
6	4
6	4
6	3
6	3
6	3

here is my data set I want to get the sum of the iD which is greater than 8 and another set which is less than 7

How I can create a DAX formula to get this?

I also have data set which creted by tablue and they use below formula,

Clients = SUM(INT([ID] > 8))

so in power bi I creted this formula,

Clinets = CALCULATE(SUM(Sheet1[ID]), FILTER(Sheet1[ID]] > 8))

Is this formula is correct is this giving the same data as the tableau formula?

Lokking formward favourable response

Thank you so much

[Mariusz · Accepted solution]

Hi @cham 

Please see the below Dax expression, it will sum all ID numbers that are  grater than 8 .

Clients = 
CALCULATE(
    SUM( Sheet1[ID] ), Sheet1[ID] > 8
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[cham]

Thank you so much