topic Re: COUNTROW that the Date is less then and Equal the current table row Date value then the current in DAX Commands and Tips

COUNTROW that the Date is less then and Equal the current table row Date value then the current

HITEK — Wed, 20 Mar 2024 22:33:58 GMT

It only filters the the records that are eqaul but not the one that are earlier ( less than )

Re: COUNTROW that the Date is less then and Equal the current table row Date value then the current

Dangar332 — Thu, 21 Mar 2024 05:56:52 GMT

hi, HITEK

try to add allexcept(dates,dates[date]) inside calculate

calculate( countrows('sheet1'), sheet[atd]<=max(dates[date]), allexcept(dates[date]) )

Re: COUNTROW that the Date is less then and Equal the current table row Date value then the current

Anonymous — Thu, 21 Mar 2024 07:17:26 GMT

Hi HITEK

First of all, thanks to Dangar332 for your timely response.

Here is my suggestion.

Sometimes there is a relationship between the two tables can cause this situation, check whether there is a relationship between "Dates" and "Sheet1" tables, if the relationship is not necessary, please delete it and then check whether the formula works properly.

Best Regards,
Yulia Xu

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

Re: COUNTROW that the Date is less then and Equal the current table row Date value then the current

Anonymous — Thu, 21 Mar 2024 09:03:10 GMT

Bonjour,

Je voudrais votre aide, je travail sur un rapport.

Je voudrais compte les occurences des memes valeurs qui se trouvent dans 4 differentes colonnes.

Ex :

Santé = CALCULATE(COUNTROWS(DataBase), DataBase[Réponse priorité 1]= "Santé"). Ça marche bien pour cet exemple, j'ai le nombre de fois où il y a Santé dans la colonne [Réponse priorité 1] de la Table "DataBase".

Maintenant je voudrais ajouter dans la même formule les colonnes [Réponse priorité 2] ; [Réponse priorité 3] et [Réponse priorité 4] pour avoir le nombre de fois où il y a Santé dans les 4 colonnes, sur une même carte dans mon rapport.

Apres je pourrais faire la mesure pour les autres types de réponse notamment L'Appui psychosocial ...

Re: COUNTROW that the Date is less then and Equal the current table row Date value then the current

HITEK — Thu, 21 Mar 2024 23:12:53 GMT

Tks Yulia, unfrotunately It's not giving me the correct results, it omits nay records from previouse dates, < or > is taken into account, actualy retunrs no results when they are used on there own !

Re: COUNTROW that the Date is less then and Equal the current table row Date value then the current

HITEK — Thu, 21 Mar 2024 23:13:52 GMT

Thanks Dangar

Unfrotunately that din;t do the trick, in the Dax it actualy dioesn;t even recognize any results if the < or > is used to filter and count.