Forum Discussion

Lhans's avatar
Lhans
Frequent Visitor
3 years ago

Help with DAX Filters please

Hello everyone, I'd be very greatful if someone could help me out! I am trying to compute new customers [newcustomercount] and have used the dax code used here for this: https://www.sqlbi.com/art...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Lhans One of the many reasons to avoid CALCULATE IMHO. Plus you are using TI functions and that's not idea. CALCULATE and the TI functions are pretty much black boxes that you can't really troubleshoot.

 

It's really not an uncommon problem. See this video link which shows the same kind of problem even with a simple SUM measure. The link should be to the exact time in the video where I discuss this. If it doesn't work, skip to 26:13.