Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a calculate function in the format of:
CALCULATE(SUM(COLUMN1),
FILTER(COLUMN1 = FALSE),
FILTER (COLUMN2 >= 1000),
FILTER(COLUMN3 = VALUE))
Can someone help me understand this more deeply:
1. What is the order in which the filters are applied? I understand that this is kind of like "sum" if all of the following are true.
2. How do i do the "opposite" of this? In my data set, if i put the opposite to just the filters, the result is wrong.
Thanks for the help!
Solved! Go to Solution.
@CarlsBerg999 It is not correctly created the query.
Try to do something like this
query= CALCULATE(SUM(yourtable[column1]), FILTER(yourtable, yourtable[column1] = "False" && yourtable[column2] >= 1000 && yourtable[column3] = "Value"))
This will give to you the sum of column 1 when the row has the 3 condiciones (beucase i put an AND = &&)
if you want, you can put OR = ||
@CarlsBerg999 It is not correctly created the query.
Try to do something like this
query= CALCULATE(SUM(yourtable[column1]), FILTER(yourtable, yourtable[column1] = "False" && yourtable[column2] >= 1000 && yourtable[column3] = "Value"))
This will give to you the sum of column 1 when the row has the 3 condiciones (beucase i put an AND = &&)
if you want, you can put OR = ||
See the link below for a detailed explanation of CALCULATE. The filter arguments are intersected (merged with the AND operator).
Would you be able to provide an example of the wrong result (and underlying data) when doing the opposite calculation?
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |