Forum Discussion

njxfoster's avatar
njxfoster
Icon for Helper I rankHelper I
4 years ago

Distinct count with date parameter

Hi Guys   I want to create a distinct count for cancel note   These "Request from Management - pick up resource hours" should only be count once since it's all from the same date but diffe...
Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hello:

What is your expected result?

Can you try for the first measure:

Cancel Note CT = DISTINCTCOUNTNOBLANK(Count_Table[Cancel_Note])
 
Then to Count the days :
Count Measure = SUMX(
VALUES(Count_Table[shift]),
[Cancel Note CT])
 

 

njxfoster's avatar
njxfoster
Icon for Helper I rankHelper I
4 years ago

Hi! Thank you for your answer

 

For example:

If I use distinctcountnoblank. the result for "request from managemnt" will only show 1 

 

I want to add condition to the measure so it count this "request from management" as 3 since there are three different agents who share same cancel reason.

 

 

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    OK. You can put calc column in table:

    Count =
    var _name = Data[Name]
    var _note = Data[Cancel_Note]
    return
    COUNTX(
    FILTER(
    ALL(Data),
    Data[Cancel_Note] = _note &&
    Data[Name] = _name)
    , Data[Cancel_Note])
     
    Then measure:
    Manager CT = CALCULATE(DISTINCTCOUNT(Data[Name]),
    Data[Count] >0)
     
    Does this work for what you need?