Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need some help

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 ...
  • amitchandak's avatar
    amitchandak
    4 years ago

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

     

amitchandak's avatar
amitchandak
Super User
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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.