Forum Discussion

PaulSB's avatar
PaulSB
Regular Visitor
3 years ago

DAX Formula

My first question was answered promptly by Charlotte, v-zhanti, but perhaps I should be approaching the problem in a diffferent way:

 

‘Dimaddon’ Table with 2 columns: Fiscal Year, Cost and single row per year

Relationship with main table, ‘Fixed’ based on Fiscal Year

Filter on Fiscal Year

 

Then what is DAX code to calculate: Fixed[Basis] + Dimaddon[Cost]

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    PaulSB ,

    one way is

     

    sumx(Fixed , Fixed[Basis] +related( Dimaddon[Cost]) )

     

    or

     

    sum( Fixed[Basis] )+ Sum(Dimaddon[Cost])

     

    • PaulSB's avatar
      PaulSB
      Regular Visitor
      3 years ago

      Thanks,

      I tried both and variations thereof, but none worked.  I have never managed to fetch the [Cost] from the Dimaddon table.

      • PaulSB's avatar
        PaulSB
        Regular Visitor
        3 years ago

        Further details of my issue:

        The ‘Dimcal’ table includes a [Fiscal Year] column

        The ‘Dimaddon’ table has two columns: [Fiscal Year] and [Cost], with one Cost value  per Fiscal Year

        The ‘Fixed’ table includes a [Basis] measure

        The ‘Details’ Table includes a [Date] column

         

        Relationships:

        ‘Dimcal’[Fiscal Year] to ‘Dimaddon’[Fiscal Year], Many to One, Single

        ‘Details’[Date] to ‘Dimcal’[FullDateAlternateKey], Many to One, Single

        ‘Details’[Detailsid] to ‘Fixed’[Detailsid], One to One, Both

         

        Objective:

        Using a single select filter in a Visual to select a Fiscal Year,

        Add a ‘Fixed’[Basis] to ‘Dimaddon’[Cost]

        Such that the output from that sum changes with the [Fiscal Year] filter selection