Forum Discussion
Solved
Sum & filter
Hello - I want to sum the amount if the value in Field 1 is not “Blank” and Field 2 is “Client” and “Blank”
Below is the sample date
Table 1
Amount | Field 1 | Field 2 |
300 |
| Client |
325 | ABC |
|
350 | DEF | Personal |
375 | GHI | Personal |
400 | YUT | Personal |
425 | CKT | Client |
450 | GHI | Client |
475 | YUT | Client |
500 | DEF |
|
The result of the above table is 2175
Thanks
Gaurav
measure = calculate(sum(tablename[Amount]),tablename[Field1] <> Blank(),tablename[Field2] == "Client" && tablename[Field2] <> Blank())
1 Reply
measure = calculate(sum(tablename[Amount]),tablename[Field1] <> Blank(),tablename[Field2] == "Client" && tablename[Field2] <> Blank())