Forum Discussion

tcburge3's avatar
tcburge3
Helper I
2 years ago
Solved

Counting Active Ticket numbers by group

Hello, I am working on a solution that looks at active ticket numbers for different groups in my organization. My original Data set looks like this. Ticket Number State Created Resolved Group...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  tcburge3 ,

     

    You can try using the following dax.

    Measure 1 =
var _columnnumber=
SELECTCOLUMNS(
    FILTER(ALL('Ticket Trend'),
    'Ticket Trend'[Date]=MAX('Ticket Trend'[Date])),"Number",'Ticket Trend'[Number])
var _count=
COUNTX(
    FILTER(ALLSELECTED('Current Incidents'),
    'Current Incidents'[Number] in _columnnumber&&'Current Incidents'[xActive]=1),
    'Current Incidents'[Number])
return
_count
    Measure 2 =
SUMX(
    FILTER(ALLSELECTED('Ticket Trend'),
    'Ticket Trend'[Date]<=MAX('Ticket Trend'[Date]) ),[Measure 1])

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  tcburge3 ,

 

You can try using the following dax.

Measure 1 =
var _columnnumber=
SELECTCOLUMNS(
    FILTER(ALL('Ticket Trend'),
    'Ticket Trend'[Date]=MAX('Ticket Trend'[Date])),"Number",'Ticket Trend'[Number])
var _count=
COUNTX(
    FILTER(ALLSELECTED('Current Incidents'),
    'Current Incidents'[Number] in _columnnumber&&'Current Incidents'[xActive]=1),
    'Current Incidents'[Number])
return
_count
Measure 2 =
SUMX(
    FILTER(ALLSELECTED('Ticket Trend'),
    'Ticket Trend'[Date]<=MAX('Ticket Trend'[Date]) ),[Measure 1])

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.