Forum Discussion

Colinu's avatar
Colinu
Helper I
8 years ago
Solved

Counting distinct (unique) values

I have been trying to count the values in a column. I have tried the belwo   Count Kit Bags = DISTINCTCOUNT(PPECheckinOut[ScanKitBagTag])   the result should be 16 but it reuturns 17 (counting th...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Colinu

     

    And this

     

    Measure 2 =
SUMX (
    ALL ( PPECheckInOut[ScanKitBag ], PPECheckInOut[ Crabs] ),
    CALCULATE ( VALUES ( PPECheckInOut[ Crabs] ) )
)
Colinu's avatar
Colinu
Helper I
8 years ago

Thanks for this. One little thing is how do i make this a whole number without decimal points? 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Colinu

 

Select the MEASURE from FIELDS>>> Go to Modelling Tab>>>Formatting and select whole number