Forum Discussion
Adding data to an aggregate?
My project has an unusual business requirement. I have a bunch of records where each record belongs to one of a few groups, along with a pass/fail value. I want to be able to get the count of how man...
There are a few approaches that could work. How about this.
You could load this new data in a second table. Join both data tables to a set of common lookup tables (read my blog here) http://exceleratorbi.com.au/multiple-data-tables-power-pivot/
then write new measures for the new data table to calculate the results. Finally write a new measure that adds the measures from bith tables together to give you the aggregate.
Does that make sense?