Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Icon for Helper V rankHelper V
3 years ago

Is the correct Dax?

Is this correct formula?

 

Party count =
CALCULATE(COUNT('Team'[ID]),
FILTER('Team','Team'[Complex]="1" &&
'Team'[Complex]="2" &&
'Team'[Complex]="3"),

FILTER('Team','Team'[Project Type]="ABC"),
FILTER('Team','Team'[Request Type]="Party"))

 

1,2,3 values are from single column i.e. Complex. 

Need Help

3 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    I think you want an OR condition, not AND - i.e. Team[Complex] is 1 or 2 or 3. You can use

    Party count =
CALCULATE (
    COUNT ( 'Team'[ID] ),
    'Team'[Complex] IN { "1", "2", "3" },
    'Team'[Project Type] = "ABC",
    'Team'[Request Type] = "Party"
)
    • PowerBIBeginer's avatar
      PowerBIBeginer
      Icon for Helper V rankHelper V
      3 years ago

      but i think you have to use filter as well, right? How it will filter values without using 'Filter' here?

      • johnt75's avatar
        johnt75
        Icon for Super User rankSuper User
        3 years ago

        You don't need to explicitly specify FILTER as an argument to CALCULATE except in limited cases. The DAX engine will automatically do the translation for you, and it isn't best practice to use an entire table as a filter, better to just put the filter on the columns you need.