topic Re: conditional all()?? in DAX Commands and Tips

conditional all()??

yasbos — Wed, 12 Jun 2024 17:55:53 GMT

Hi. I have a calculate function. I need to decide on the fly whether it uses all() (based on user input in a checkbox) as one of its arguments. Is this at all possible? Calculate( something, if(checkbox is true, all(dates), do nothing) )

Re: conditional all()??

lbendlin — Wed, 12 Jun 2024 19:53:45 GMT

if(checkbox is true, Calculate( something, all(dates)))

You get the "do nothing" for free if you omit the "else" parameter.

Re: conditional all()??

Anonymous — Thu, 13 Jun 2024 01:41:19 GMT

Hi yasbos ,

Maybe you can try formula like below:

ConditionalTotalSales = IF( [SelectedOption] = "Include All", CALCULATE( [TotalSales], ALL('Calendar') ), CALCULATE( [TotalSales] ) )

SelectedOption = SELECTEDVALUE(Checkbox[Option], "Exclude All")

TotalSales = SUM(Sales[Sales])

Best Regards,
Adamk Kong

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

Re: conditional all()??

yasbos — Thu, 13 Jun 2024 20:17:57 GMT

Thanks so much Anonymous . I forgot to mention that I did know this solution, but I was hoping for a more localized decision because the calculate function that I have is much larger than just one line. I was hoping to modularize the code. Thanks so much for your help, nonetheless.

Re: conditional all()??

yasbos — Thu, 13 Jun 2024 20:18:47 GMT

Thanks so much, lbendlin . I forgot to mention that I did know this solution, but I was hoping for a more localized decision because the calculate function that I have is much larger than just one line. I was hoping to modularize the code. Thanks so much for your help, nonetheless.

Re: conditional all()??

yasbos — Thu, 13 Jun 2024 20:41:51 GMT

Also, thank you again so much for taking the time and putting the efforts into this, Anonymous . That's awesome!