topic Need some help in DAX Commands and Tips

Need some help

Anonymous — Mon, 14 Feb 2022 11:10:04 GMT

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 ?

Re: Need some help

amitchandak — Mon, 14 Feb 2022 11:17:36 GMT

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

then new measure

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

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])

Re: Need some help

Anonymous — Mon, 14 Feb 2022 11:25:27 GMT

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.