Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys
I'm making an accounting report that has several report tables, each one of them with a total. I need to create a field that add each of those totals. Please see the capture below.
Any help will be appreciated! Thanks.
@juandroid - are each of the tables a unique dataset? If so, you could build a measure using DAX code to calculate the sum of each total. Could you reply with a screenshot of the dataset/field names being used?
All the tables reports were created from the same dataset. I just take the numbers and create the tables according to wich type of data they are; for example in the picture of the first comment, the table ACTIVOS CORRIENTES (regular assets) shows the values of the column CUENTA that starts with the numbers 11 and 13 (I made this using a normal filter); while the table ACTIVOS NO CORRIENTES (non regular assets) shows the values that starts in 12 and 14.
All this data comes from a single dataset called "masteraccounting" that has all the accounts, not only assets but also the entire accounting of a company. Below there's two captures: the first is the filter I use to create each table and the other is the dataset amsteraccounting.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |