Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need Help in calculating Historical cases

Hello All,   i am looking for a helping hand who can suggest me or help me to calculate sum of historical cases.   The Data looks as below   let Source = Table.FromRows(Json.Document...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try with a filter like

    filter(all(Table[sceniro]),Table[sceniro] in except(all(Table[sceniro]),values(Table[sceniro])))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try with a filter like

filter(all(Table[sceniro]),Table[sceniro] in except(all(Table[sceniro]),values(Table[sceniro])))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak, Greg_Deckler  Thanks for the reply means a lot.

 

I tried your solution, by doing some changes, 

 

_HistoricalCases = CALCULATE(SUM('Table'[Historical Cases]), filter(all('Table'),'Table'[Platform] in except(all('Table'[Platform]),values('Table'[Platform])))
)

 

I got the below output.

 The total value which i see here 3155 is what i am expecting in both the rows..

 

 

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

     

    If you've fixed it by your own, please kindly mark it as a answer that help others find it more quickly. thanks!

    If  not, please kindly elaborate more.