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 all,
I'm lost at this moment. I've 8 tables (8 companies) calle ReportingBalance_Company1, ReportingBalance_Company2, et cetera.
The values in each table must be calculated per row, because I need the possibility to filter them later on. Now I've this:
Solved! Go to Solution.
Hi @AltusTellus ,
I made a sample .pbix file according to your description and used the measure you provided,but it seems no problem,see below:
Before adding one row in company 3,it shows :
After adding one row valued 75,it shows:
My measure is as below:
Measure = CALCULATE(SUM(tb_ReportingBalance_Company1[Amount PL]),FILTER('tb_ReportingBalance_Company1','tb_ReportingBalance_Company1'[Type] = 110)) +
CALCULATE(SUM('tb_GLAccounts_Company2'[Amount PL]),FILTER('tb_GLAccounts_Company2','tb_GLAccounts_Company2'[Type] = 110))+CALCULATE(SUM('tb_GLAccounts_Company3'[Amount PL]),FILTER('tb_GLAccounts_Company3','tb_GLAccounts_Company3'[Type]=110))
Pls check my .pbix file ,try to produce your senario and show me the error.
@AltusTellus , this seems correct.
The other way would be that you append the tables into one table.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
@amitchandak I've the 8 tables appended to 1 new table. How can I filter with another table (like I wrote above)? Many thnx.
Hi @AltusTellus ,
I made a sample .pbix file according to your description and used the measure you provided,but it seems no problem,see below:
Before adding one row in company 3,it shows :
After adding one row valued 75,it shows:
My measure is as below:
Measure = CALCULATE(SUM(tb_ReportingBalance_Company1[Amount PL]),FILTER('tb_ReportingBalance_Company1','tb_ReportingBalance_Company1'[Type] = 110)) +
CALCULATE(SUM('tb_GLAccounts_Company2'[Amount PL]),FILTER('tb_GLAccounts_Company2','tb_GLAccounts_Company2'[Type] = 110))+CALCULATE(SUM('tb_GLAccounts_Company3'[Amount PL]),FILTER('tb_GLAccounts_Company3','tb_GLAccounts_Company3'[Type]=110))
Pls check my .pbix file ,try to produce your senario and show me the error.
Before you append the tables, make sure that you have a company column in each table specifying which company the rows are related to. When you have this you should be able to use that column as a column/row dimension or a filter in a slicer.
Br,
J
Hi, thnx for your reply. But when I add an third row, I don't get the correct values, why?
P.S. Your suggestion for 1 table is my second option.
User | Count |
---|---|
113 | |
106 | |
83 | |
67 | |
42 |
User | Count |
---|---|
157 | |
110 | |
84 | |
78 | |
60 |