Forum Discussion
Helper IIISumx not return good total
Thanks you so much ! it's works
Helper IIIThanks Ashish_Mathur
i see the pbi and your test and I will back
On the other hand I would like to know why you have 2 for the month of June 2023 and not 1?
Super UserTest the result and study the solution thoroughly. If there are problems, then clearly show the problem and also the expected result.
- Juju123
I see pbix and the result it's not good.
The result i want it's :
The problem is that the measurement counts the number of dates that the reference to per month.
For example for the month of October we have the number 5 because the reference to 5 different dates in October.
Whereas what I would like is if the reference appears 5 times in the month of October then I count the reference only 1 time - Ashish_Mathur
PBI file attached
- Juju123
Thanks you so much ! it's works
- Ashish_Mathur
You are welcome.
- Juju123
J'ai appliqué la formule dax sur un plus gros échantillon de données et le rapport est très très lent.
Est-il possible de remplacer la fonction résumé par une autre ou d'utiliser une façon de faire en DAX ?
- Juju123
I find a solution
I create a concatenate column in database and after i use only this dax formula
NEW_NUMBER_REF = COUNTROW('TABLE'[KEY_CARD])