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've an issue with a matrix table. Let's start with what I have at this moment:
I added a table with KPI's with measures for calculating the sum of values per G/L, e.g.
Hi @AltusTellus ,
The setup of the relationship between Budget and dimension tables must be the same as for the Reporting balance table then you should make the measure similar also but based on the budget values.
Is it possible to have the budget done at the same dimensions table as your reporting balance?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi Miguel,
There are three tables involved:
1. 'ReportingBalance' with the column [GLAccountID] linked to 2. 'GLAccounts'
2. 'GLAccounts' with column [GLAccountID]
3. 'Budget' with the column [GLAccountID] linked to 2. 'GLAccounts'
I have one page with a matrix table with rows for the [GLAccountsID] and columns for Realisation versus Budget. The values works perfect.
But, in case of the table (or matrix) I send with my first comment, I get the wrong values. What am I doing wrong? Any other suggestions?
Hi @AltusTellus ,
Is it possible to send out a mockup file with sample data?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |