Need some help

[Anonymous]

Hello everyone , so i have this PowerBI ( sorry for showing you the excel) and i want to do a distinct SUM but the thing is that for the 4th and 5th is showing the same value and when i do the sumx and Disting function it`s showing me just one value for both of them and i want a value for each day even if they are the same. Can u help me please doing this somehow ?

[amitchandak · Accepted solution]

@Anonymous , If [% of new for] is a column

then new measure

Sumx(summarize(Table, Table[Date], Table[% of new for]) ,[% of new for])

or

Sumx(summarize(Table, Table[Date],"_1", max(Table[% of new for])) ,[% of new for])

if this is a measure

Sumx(summarize(Table, Table[Date],"_1", maxX(Table, Table[% of new for])) ,[% of new for])

[Anonymous]

First one seems to work perfectly for me , i gladly thank you because i was searching for this kind of response for a long time . Have a good day and thank you one more time.