Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DISTINCTCOUNT with multiple Filters

Hello, I am trying to get the count of a column where the column value is equal to something. I have the below formula which works with 1 filter: Windows = CALCULATE( DISTINCTCOUNT( 'enterprise-...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a measure like

     

    CALCULATE(
    DISTINCTCOUNT( 'enterprise-attack'[Value.x_mitre_platforms] ),
    FILTER(
    'enterprise-attack',[Value.x_mitre_platforms] in {"Windows","Linux","macOS"}
    )
    )

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try a measure like

 

CALCULATE(
DISTINCTCOUNT( 'enterprise-attack'[Value.x_mitre_platforms] ),
FILTER(
'enterprise-attack',[Value.x_mitre_platforms] in {"Windows","Linux","macOS"}
)
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello, thanks for that it doesnt appear to error anymore :). However, i only get an answer of 1 when ideally it should be 3?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      ignore. Appears to be now working. Thank you