Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Not sure if this is possible with my current data layout, but I am trying to create a conditional measure in a Table Visual that will calculate the balance for 2 types of funds (fixed & variable) in the single "Balance" column based on if there is a value in the "Contract Value" column:
Calculation conditions/definitions:
Data sources/relationship:
** Yellow highlighted below = relationship between tables
** "Contract Value" column in Table Visual = 'Agreement-Provision'[Total Amount]
** 'CPConsolidated' is an Excel file; 'Agreement-Provision' is an MS Access DB table
Any help/suggestions on DAX or data layout to achieve this would be appreciated!
Solved! Go to Solution.
Hi b_rice,
Just a suggestion,have you tried calculated Column instead of the Measure.
Looking at your condition, I think i will be better to use calculated column instead
Hi b_rice,
Just a suggestion,have you tried calculated Column instead of the Measure.
Looking at your condition, I think i will be better to use calculated column instead