Hola necesito ayuda con Dax

[manuel_yhvh]

Resulta que debo realizar un conteo de incidentes de un mismo usuario dentro de un mismo mes, necesito saber cuanto incidentes realiza a soporte un mismo usuario, he intentado de muchas maneras pero no consigo el resultado.

Estoy tratando de utilizar el sigiente Dax pero no funciona, soy relativamente nuevo en este mundo.

PedidosEnMesSeleccionado =
VAR CurrentFirstOrderDate = SELECTEDVALUE('Data'[First Order Date (EOM)])
VAR MonthsAfter = SELECTEDVALUE('Months After'[Value])
VAR SelectedMonth = EOMONTH(CurrentFirstOrderDate,MonthsAfter)
RETURN
CALCULATE(
COUNTROWS('Data'),
FILTER(
'Data',
'Data'[Customer ID] = SELECTEDVALUE('Data'[Customer ID]) &&
EOMONTH('Data'[Order Date],0) = SelectedMonth
)
)

[Anonymous · Accepted solution]

Hi @manuel_yhvh 

Depending on your description, you may want to consider, for example, whether you have a corresponding date in your corresponding data table after setting the Months After' [Value] setting, for example, the maximum date in your data table is 2023/5/1 But the date you filter may be more than 5/1/2023, so a null value may be returned.

If the above suggestions did not help you, can you provide some pictures of the results you expect or pictures of the current error?

Best Regards!

Yolo Zhu

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