The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance 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
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |