cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vanetti
Frequent Visitor

Use SUMX with FILTER with 2 filters

I want to sum the volume of deliveries that has date of deliveries creation(Data Cri ajust) lower than a certan day(Data base) AND has shipping date(Data formatada fat) higher than that that specific day.

 

I manage to get here: 

Volume remessas vivas = sumx(filter(CV_BILLINGLOGGSB;CV_BILLINGLOGGSB[Data Cri ajust]<Planilha1[Data base]);CV_BILLINGLOGGSB[Volume Faturado])

 

Then I tryed to use AND, but got an error:

Volume remessas vivas = sumx(filter(CV_BILLINGLOGGSB;CV_BILLINGLOGGSB[Data Cri ajust]<Planilha1[Data base] and CV_BILLINGLOGGSB[Data formatada fat]>Planilha1[Data base]);CV_BILLINGLOGGSB[Volume Faturado])

 

Can I use the "filter" function inside the "sumx" for 2 or more parameters?

If yes, how?

1 ACCEPTED SOLUTION
KHorseman
Community Champion
Community Champion

The and operator is &&, not the word "and".

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
KHorseman
Community Champion
Community Champion

The and operator is &&, not the word "and".

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Great! Thanks!

There is an AND() function that serves a similar purpose, but it is limited to two arguments. In general I recommend avoiding this function and using the && operator instead, since it allows essentially unlimited conditions to be strung together.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors