cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

summarizecolumns and if statement

Hello,

something I don't understand.

I want count a if statement with two columns.

Test = if(sum('Table'[Column1]) >0 && sum('Table'[Column2])>0,1,0)

What I want is the Sum of Test. I'll tried this.

test2 = var table1 = SUMMARIZECOLUMNS('Table'[AccountID],"Sum",if(sum('Table'[Column1]) >0 && sum('Table'[Column2])>0,1,0)) return sumx(table1,[Sum])

But I'll get an error if i want show it together with AccountId.

Is there somebody who could explain me this behaviour of DAX 🙂

I don't understand why I can't use AccountId with this measure.

Thanks and take care,

Anna

1 ACCEPTED SOLUTION
Community Support

``test = SUMX(ADDCOLUMNS('Table',"SUM",IF([Column1]>0&&[Column2]>0,1,0)),[SUM])``

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Community Support

``test = SUMX(ADDCOLUMNS('Table',"SUM",IF([Column1]>0&&[Column2]>0,1,0)),[SUM])``

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

@AnnaAliera18 , Use summarize with Addcolumns

test2 = var table1 = Addcolumns(Summarize('Table', 'Table'[AccountID]) ,"Sum",if(sum('Table'[Column1]) >0 && sum('Table'[Column2])>0,1,0))
return sumx(table1,[Sum])

New Member

Thanks the error is gone but the calculation is wrong.

the Total gets 5

how  I can get 3 in my total?

What I want is sum the 1 in the column. If I use a physical table it works fine, but i want use a VAR and only one measure if it works.

Thanks for your help 🙂

Announcements

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors