Forum Discussion

jereaallikko's avatar
jereaallikko
Icon for Helper III rankHelper III
5 years ago
Solved

Help with if Function in DAX

Hi all,   I am trying to show number of actions needed for my team. The idea is to create a DAX (or custom column if needed) to show number of items where some actions are needed.   Data table il...
Need Help DAX
Tip & Tricks
  • ERD's avatar
    ERD
    5 years ago

    Hi jereaallikko ,

    Try this measure:

    #CountItems = 
COUNTAX(FILTER(T, T[Status] IN {"Pending","Open","Cancelled","Closed"} && OR(T[InfStatus] = "Waiting", T[Group] = "Sales")), T[ID])

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

jereaallikko's avatar
jereaallikko
Icon for Helper III rankHelper III
5 years ago

Hi ERD 

 

That worked out well! One more question:

 

Is there a way to modify the measure, that if there are no actions needed, the result will show as 0? Now it shows as "blank". I am using Card as a visual.

 

Thanks in advance.

 

-Jere

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

jereaallikko ,

#CountItems = 
COALESCE(
COUNTAX(FILTER(T, T[Status] IN {"Pending","Open","Cancelled","Closed"} && OR(T[InfStatus] = "Waiting", T[Group] = "Sales")), T[ID]),
0)