Forum Discussion

ledoyle1121's avatar
ledoyle1121
Frequent Visitor
8 years ago
Solved

DAX formulas for Where statements

Hi,   I have a column in my data which is called "NPS Category", which classifies each Case Number listed. Each row in the data either have the values of "Promoter", "Detractor", or "Neutral" withi...
Need Help
  • mattbrice's avatar
    mattbrice
    8 years ago
    Measure =
CALCULATE (
    DISTINCTCOUNT ( Table[CaseNumber] ),
    Table[NPS Category] = "Neutral"
)
mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
8 years ago
Measure =
CALCULATE (
    DISTINCTCOUNT ( Table[CaseNumber] ),
    Table[NPS Category] = "Neutral"
)
ledoyle1121's avatar
ledoyle1121
Frequent Visitor
8 years ago

Not sure what I was doing wrong before - but that worked perfect, thanks!!