Forum Discussion
Running Total with duplicate dates in DirectQuery
Anonymous , Try like
RunningTotal =
CALCULATE( SUM(CdeClientEnCours[Quantité restante]),
FILTER(
allselected('CdeClientEnCours'),
CdeClientEnCours[Date livraison]<= max(CdeClientEnCours[Date livraison]) +rand()/100
))
or refer
Rank Tie breaker
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
amitchandakThanks for your answer !
I tried your formula, but it still does tie on the same date :I looked on the posts you linked, but I run in the second issue I mentioned :
To do multiple columns ranking, I need to compare the dates with other columns somehow, using an integer. But the column "Date de livraison" is in Date format, and needs to be because it is linked to a Calendar table.
I can't do a ranking of the Dates via RankX because it shows me the error :
“It is impossible to determine a unique value for column “Date Livraison” from table CdeClientEnCours. This can occur when a formula or measure references a column with many values, without specifying an aggregation as min, max, count, and sum to get a unique result.”
I think the solution lies around this problem, but i'm quite new to PowerBI and I don't know how I can overpass this issue of converting the Date to an integer inside a Measure.
Thanks in advance for your help !