Countrows

[Palobidonde]

Hola! Estoy teniendo problemas con una formula dax: 

Mi tabla tiene 766 filas, pero cuando utilizo la formula 

Total sour = COUNTROWS('Data 1 -dinohunter') para que me traiga ese valor, me trae uno totalmente diferente.

Alguien podria ayudarme?

[Anonymous · Accepted solution]

Hi @Palobidonde ,

This is due to the influence of the filter context, you need to remove the filter context.

Please replace your dax formual with below:

Total sour = COUNTROWS(All('Data 1 -dinohunter'))

For more details, you can read related document: Row Context and Filter Context in DAX - SQLBI , Filter context in DAX - SQLBI

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ahmedx]

pls try this

Total sour = CALCULATE (COUNTROWS('Data 1 -dinohunter') ,REMOVEFILTERS())