Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
manuel_yhvh
Regular Visitor

Hola necesito ayuda con Dax

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
)
)

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.