Forum Discussion
Helper IIISumx not return good total
Thanks you so much ! it's works
Super UserHi,
PBI file attached.
Hope this helps.
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?
- Ashish_Mathur
Test 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])