Forum Discussion
Helper IIISumx not return good total
Thanks you so much ! it's works
Super UserI think you are confusing between measures and calculated columns. Share some data, explain the question and show the expected result.
Helper IIIHi Ashish_Mathur ,
In fact I want to display the reference number according to the selection made by the user.
User has several filters.
Depending on the filters that it will select, I must display the reference number which is displayed in a card.
Currently I have this table but the final result I have in the table does not match and the result I have in my map does not match also.
For example, to test that my measurement works, I selected the year 2023 in my data.
My table shows me 94 lines but my measure calculate 195 references. I think my measure
I create this Dax formula (it's measure column) :
Nb Ref. = DISTINCTCOUNT(TABLE[Ref.])
This Dax column depend on this calculated column
Ref. = REF&"-"LIGNES_NUMBER
Sorry but i can't attach pbix file in my comment. When i want to share pbix, i have this error The file type (.pbix) is not supported.
- Ashish_Mathur
Upload the file to One Drive and share the download link of the PBI file.
- Juju123
i don't know if you know smash. I put the pbix in this plateform
you can dowload it with this link :
- Ashish_Mathur
I am not comfortable with using that platform.