Forum Discussion
Why total = 0 ?
Hello,
I did this dax new measure to count the new clients, but the total appears 0. How to count them?
I've tried this but =0 too:
Nouveaux clients (1an) - count = calculate (([Nouveaux clients (1an)]) , all('SG LUBRIFIANTS - 2019-2023 data corrigées'))
Thanks!
Thanks for the reply from tamerj1 , please allow me to provide another insight:
Hi, sportive92003
Regarding the issue you raised, my solution is as follows:
In response to your question, I offer two approaches:
1.The first is to use the HASONEFILTER () function as the basis for judgment, and then output the SUMX () function as the aggregate.
Here are the related links, I hope you will be helpful:
Dealing with Measure Totals - Microsoft Fabric Community
Measure Totals, The Final Word - Microsoft Fabric Community
2.The second is to convert the measures into groups of calculations and then modify the aggregation:
You can try the following code as a calculated column:
Then modify the way he aggregates:
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Because SELECTEDVALUE returns BLANK at the total level for the fact that there is no single value available in the filter context of the total.
is [date_de_la_facture] a measure a column? If measure, what's the DAX? And what's your reason for using ALL? Is it to remove an existing filter in the table visual or a slice?Thanks for the reply from tamerj1 , please allow me to provide another insight:
Hi, sportive92003
Regarding the issue you raised, my solution is as follows:
In response to your question, I offer two approaches:
1.The first is to use the HASONEFILTER () function as the basis for judgment, and then output the SUMX () function as the aggregate.
Here are the related links, I hope you will be helpful:
Dealing with Measure Totals - Microsoft Fabric Community
Measure Totals, The Final Word - Microsoft Fabric Community
2.The second is to convert the measures into groups of calculations and then modify the aggregation:
You can try the following code as a calculated column:
Then modify the way he aggregates:
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
