Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |