Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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êsUser | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |