Forum Discussion
DAX : Filtering for multiple accounts
EvanBeiser How are you going to Visualize this infromation?
If you create a Table with Account and Amount and use an Account Slicer - don't you get what you want?
Then you don't really need a Measure (especially if you have many accounts)
Not sure what you are trying to achieve?
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.
EvanBeiser Create a Table Visualization as in Picture. All accounts on Left - 2 accounts selected on Right.
This works the same way regardless of how many accounts you have.
Regarding the Gross Margin - it should work the same way.
What formula are you using?