Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
I have two columns with integers.
I need to sum this two columns, and if the value is 1 or greater, then sum 1, else 0.
How can I do this in DAX?
Thank you!
Example:
Column1 Column2 Result
1 1 1
0 0 0
0 1 1
1 0 1
Solved! Go to Solution.
Finally I've changed it to PowerQuery with the following expression. The solution in DAX also works, but according to the link below, it's faster and better to use Power Query computed columns whenever the expression only depends on other columns of the same row of the table where you create the new column
PowerQuery Computed Column - The better choice
Column = if ([Column1]+[Column2]>0) then 1 else 0
DAX Calculated Column:
Column = if(Table1[Column1]+Table1[Column2]>0;1;0)
Thanks!!
https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/
Hi ,
you can use this measure
Regards,
Husna
@Anonymous why measure, not calculated column? measure uses more memory, from my experience, for aim to row-by-row calculations column is much better
Are you sure? I came from QlikView, and it better to have simple calculations done in processing time rather than in load time.
But I'm not sure in PowerBi
@Anonymous agree. but there is a difference between calculated column and measure. column is about row context (which is less), measure is about filter and query context.
@az38 I havent used measure over there , it a column where in formula is inserted .
Finally I've changed it to PowerQuery with the following expression. The solution in DAX also works, but according to the link below, it's faster and better to use Power Query computed columns whenever the expression only depends on other columns of the same row of the table where you create the new column
PowerQuery Computed Column - The better choice
Column = if ([Column1]+[Column2]>0) then 1 else 0
DAX Calculated Column:
Column = if(Table1[Column1]+Table1[Column2]>0;1;0)
Thanks!!
https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |