cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

DAX'S HELP

Next the formula giving incorrect value.
Please help
QTY FACTURADO ?
CALCULATE(SUM(SO_BI_FACT[QTY]),
FILTRO(SO_BI_FACT,
SO_BI_FACT[CLASSIFICATION] <> "C&I"
&& SO_BI_FACT[FLAG]-1 ))
+
CALCULATE(SUM(SO_BI_FACT[QTY2]),
FILTER(SO_BI_FACT,
SO_BI_FACT [Classification] "C&I"))
1 REPLY 1
Highlighted
Super User IV
Super User IV

Re: DAX'S HELP

@SonaSingh123 

 

Declare variables and return one by one and see where it is having an issue.

If possible, please share the expected output and sample table.

 

 




Regards,
Nandu Krishna

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍

Proud to be a Super User!

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors