conditional all()??

[yasbos]

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) )

[v-kongfanf-msft · Accepted solution]

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.

[v-kongfanf-msft · Accepted solution]

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.

[yasbos]

Also, thank you again so much for taking the time and putting the efforts into this, @v-kongfanf-msft . That's awesome!

[yasbos]

Thanks so much @v-kongfanf-msft . 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.

[lbendlin]

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

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

[yasbos · Accepted solution]

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.