Adding data to an aggregate?

[Supertanker]

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 many passes and fails there are total, summing up passes and fails by group. PowerBI lets me do this easily.

Here's the unusual bit: I have one secretive group that, instead of the data coming from the main table with all the summed pass/fail records, gives me data in the form of a single record with some # of passes and some # of fails. How can I integrate this with the main table such that I can see 1) Total number of pass/fail records across all the data with 2) filtering/grouping by group and 3) the "secret" shows up just like any other group (except pulled from this single record instead of summed).

I was able to make two Measured columns (for pass and fail for that group) with DAX but I can't filter by group with that. I was thinking of inserting bogus columns in an earlier step in the data collection process.

[BhaveshPatel]

You can use query editor for this as well. Filter out all the secretive group records from your main table and later on create another query only of secretive group. Use Groupby feature in Query editor and finally append the query on top of your first query.

Would you please post a sample data for us to create a solution using multiple approaches. It would be new learning for everyone.

[MattAllington]

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?