excel - Error in dax formula -


i'm new dax. im trying sum amount of fatalities per year. formula:

= summarize (     'tablecrash',     'tablecrash'[year],     "fatal", sum ( 'tablecrash'[fatalities] ) ) 

- example:

summarize(<table>, <groupby_columnname>[, <groupby_columnname>]…[, <name>, <expression>]…) 

source

there isn't wrong formula. problem how using it. because returns table incorporate snippet larger formula. can install dax studio excel test these snippets. in case execute:

evaluate  (     summarize (         'tablecrash',         'tablecrash'[year],         "fatal", sum ( 'tablecrash'[fatalities] )     ) ) 

but if have table contains year , fatalities don't need formula calculate sum of fatalities. try drop both fields power view or pivot table , fatalities sum automagically.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -