DAX : Filtering for multiple accounts

That is currently what we have, but the issue with this is that when we go to create visuals for all of this financial information we can not filter for multiple accounts easily.  All of the accounting information is being pulled in from one general ledger.

As an example for visuals, we are using the LinearGauge to show gross margin as a percent of revenue by placing a gross margin measure in the value field and revenue measure in the target value field. I am not sure if there is a way to correctly filter for these two sepereate amounts when the information is coming from one table.

The other issue with creating another table is that we are dealing with a lot of data.Some have mentioned to avoid creating many additional tables because of out data set size.