Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |