Forum Discussion
Solved
DAX formula
| 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
2 Replies
Thank you so much
