Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
About point 2. It will depend on if you are using related dimension table column to filter data (or using more than 2 columns for criteria).
If not, you don't need Filter().
Though, in the background, it's being converted to Filter(ALL(table),Condition).
As well, when you use two different columns as condition, you'll need to write explicit expression using Filter() rather than relying on automatic conversion in the background.
Basically, I make it a habit to use FILTER(), so that I don't stumble with more complex conditions (i.e. all my Calculate() construct has same base syntax).
See link for more detailed explanation of filter argument in Calculate().
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
You can use following construct.
AvgIf = Calculate(Average(Table[Column]),Filter(Table,[CriteriaColumn]="Criteria"))
About point 2. It will depend on if you are using related dimension table column to filter data (or using more than 2 columns for criteria).
If not, you don't need Filter().
Though, in the background, it's being converted to Filter(ALL(table),Condition).
As well, when you use two different columns as condition, you'll need to write explicit expression using Filter() rather than relying on automatic conversion in the background.
Basically, I make it a habit to use FILTER(), so that I don't stumble with more complex conditions (i.e. all my Calculate() construct has same base syntax).
See link for more detailed explanation of filter argument in Calculate().
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |