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

1 Reply

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