Table Visual Conditional Measure

[b_rice]

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:

• Variable (no value in "Contract Value" column): [Measure]:"Total Accrued" - [Measure]:"Total Paid"
• Fixed (value in "Contract Value" column): "Contract Value": $X - [Measure]:"Total Paid"

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!

[sandeephijam · Accepted 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