Forum Discussion

msit19's avatar
msit19
Frequent Visitor
5 years ago
Solved

Calculation error in measure

Hello friends How can I address the following problem
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    msit19 , Summarize returns table. You need to return a value like

     

    examples

    sumx(summarize(Table, Table[Date],"_1",max(Table[Available])),[_1])

     

    sumx(summarize(Table, Table[Date],"_1",Sum(Table[Available])),[_1])

amitchandak's avatar
amitchandak
Super User
5 years ago

msit19 , Summarize returns table. You need to return a value like

 

examples

sumx(summarize(Table, Table[Date],"_1",max(Table[Available])),[_1])

 

sumx(summarize(Table, Table[Date],"_1",Sum(Table[Available])),[_1])