Forum Discussion

acs's avatar
acs
Regular Visitor
9 years ago
Solved

A conditional MAX?

Hello - have been learning a lot by reading these forums and all the helpful posts on here. Now I've run up against a problem I cannot find the answer for and hoping someone can help.   I have data...
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    acs,

     

    Could you give us a expected chart as the sample? To get the vaule you want, we can use ALLEXPECT function.
    TypeTotal = CALCULATE(SUM(Table1[Sales]),ALLEXCEPT(Table1,Table1[Type]))
    ProjectTotal = CALCULATE(SUM(Table1[Sales]),ALLEXCEPT(Table1,Table1[Type],Table1[Project]))
    VersionTotal = CALCULATE(SUM(Table1[Sales]),ALLEXCEPT(Table1,Table1[Type],Table1[Project],Table1[Version]))

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

acs,

 

Could you give us a expected chart as the sample? To get the vaule you want, we can use ALLEXPECT function.
TypeTotal = CALCULATE(SUM(Table1[Sales]),ALLEXCEPT(Table1,Table1[Type]))
ProjectTotal = CALCULATE(SUM(Table1[Sales]),ALLEXCEPT(Table1,Table1[Type],Table1[Project]))
VersionTotal = CALCULATE(SUM(Table1[Sales]),ALLEXCEPT(Table1,Table1[Type],Table1[Project],Table1[Version]))

 

Regards,

Charlie Liao