Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI, I have a requirement where I have to check for each category, and if for that category any flag is "Yes', then I need another column which says "True" for all values of that category. eg. `
Column1 Flag Final_Answer
A Yes True
A No True
A No True
B No False
B No False
C No False
Notice that only if a category in Column1 has the value "Yes" in Flag then Final_Answer will be "True" for all the rows for the category. Since, "B" and "C" do not have "Yes', the corresponding value in Final_answer is "False:. How can I achieve this in DAX powerbi? Any help is appreciate. Thanks
Solved! Go to Solution.
Hi @Anonymous ,
You could change @amitchandak 's expression like below, it is calculated column
Column = if(isblank(countx(filter('Table', [Column1] = earlier([Column1]) && [Flag] ="Yes"),[Column1])),"False", "True")
Or you also could try to use measure to achieve this.
Measure = if(CALCULATE(DISTINCTCOUNT('Table'[Flag]),ALLEXCEPT('Table','Table'[Column1]))>1,"True", "False")
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Try a new column like
new column = isblank(countx(filter(Table, [Column1] = earlier([Column1]) && [Flag] ="Yes"),[Column1]),"No","Yes")
Hi Amit, Thanks for replying. But, im getting errors on the last part of your DAX query. Could you please check once? Thanks
Hi @Anonymous ,
You could change @amitchandak 's expression like below, it is calculated column
Column = if(isblank(countx(filter('Table', [Column1] = earlier([Column1]) && [Flag] ="Yes"),[Column1])),"False", "True")
Or you also could try to use measure to achieve this.
Measure = if(CALCULATE(DISTINCTCOUNT('Table'[Flag]),ALLEXCEPT('Table','Table'[Column1]))>1,"True", "False")
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |