Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have two tables in my Data Model - A dimensions table and a transaction table - see examples
Indicator | Description | Frequency |
M1 | Measure 1 | Monthly |
M2 | Measure 2 | Quarterly |
M3 | Measure 3 | Monthly |
M4 | Measure 4 | Annual |
M5 | Measure 5 | Monthly |
M6 | Measure 6 | Monthly |
M7 | Measure 7 | Monthly |
M8 | Measure 8 | Monthly |
M9 | Measure 9 | Quarterly |
M10 | Measure 10 | Annual |
Indicator | Date | Value | Value Calculated |
M1A | 01/01/2019 | 8 | |
M1B | 01/01/2019 | 9 | |
M2A | 01/01/2019 | 30 | |
M2B | 01/01/2019 | 2 | |
M2C | 01/01/2019 | 1 | |
M4B | 01/01/2019 | 5 | |
M4B | 01/01/2019 | 5 | |
M1 | 01/01/2019 | 17 | |
M2 | 01/01/2019 | 15 | |
M3 | 01/01/2019 | 1 | 1 |
M4 | 01/01/2019 | 25 | 25 |
M5 | 01/01/2019 | 24 | |
M6 | 01/01/2019 | 16 | 16 |
M7 | 01/01/2019 | 15 | 15 |
M8 | 01/01/2019 | 12 | 12 |
M9 | 01/01/2019 | 22 | 22 |
M10 | 01/01/2019 | 120 | 120 |
M1A | 01/01/2019 | 14 | |
M1B | 01/01/2019 | 10 | |
M1 | 01/02/2019 | 24 | |
M3 | 01/02/2019 | 18 | 18 |
M5 | 01/02/2019 | 123 | 123 |
M6 | 01/02/2019 | 167 | 167 |
M7 | 01/02/2019 | 38 | 38 |
M8 | 01/02/2019 | 84 | 84 |
M1A | 01/01/2019 | 54 | |
M1B | 01/01/2019 | 24 | |
M1 | 01/03/2019 | 78 | |
M3 | 01/03/2019 | 109 | 109 |
M5 | 01/03/2019 | 24 | 24 |
M6 | 01/03/2019 | 456 | 456 |
M7 | 01/03/2019 | 234 | 234 |
M8 | 01/03/2019 | 97 | 97 |
The tables are linked by Indicator. Once data is added to the Transaction table some of the Indicators are calculated (for example M1A + M1B = M1, or M2A/M2B = M2). On my report I am using the Indicator & Description from the Dimension table and the LASTDATE and Value Calculated from the transaction file. I want to add a Year to Date Column to the report and I have created a measure to calculate this. Where the Indicators, are not calculated from other values, the data displays on the report, but where there is another calculation the data does not display (M1, M2, M4)
I know the calculation is working perfectly, because if I create a separate table and just use the Indicator field from the transaction table and the caculated Year to Date it displays perfectly. But once I connect to the Dimension Table I cannot get the values for M1, M2 & M4.
Solved! Go to Solution.
HI @Anonymous ,
Can you please share more detail information to help us clarify your scenario?(e.g. sample data, dax formula...)
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
I figured out a work around, so no panic
Thanks
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |