Forum Discussion

Nigel29's avatar
Nigel29
New Member
4 years ago
Solved

Measure not recognizing columns

I'm new to Power BI and have really been struggling with these DAX formulas. I've been trying to do gross profit margin as a new measure but it seems the columns are not being recognised and I can't figure out why or where I went wrong. 

 

  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Nigel29 you can't reference a "naked" column in a measure without first supplying to it a row context (in most cases the straight forward solution is just wrap it up with an aggregation function). In your case you just need to add an aggregation, probably SUM.
    So write: DIVIDE (SUM('Table'[Column1]),SUM('Table'[Column2]))
     


    Showcase Report – Contoso By SpartaBI

    Check it out! Give it a thumbs up if you liked it 🙂

          

5 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    Nigel29 you can't reference a "naked" column in a measure without first supplying to it a row context (in most cases the straight forward solution is just wrap it up with an aggregation function). In your case you just need to add an aggregation, probably SUM.
    So write: DIVIDE (SUM('Table'[Column1]),SUM('Table'[Column2]))
     


    Showcase Report – Contoso By SpartaBI

    Check it out! Give it a thumbs up if you liked it 🙂

          

    • Nigel29's avatar
      Nigel29
      New Member
      4 years ago

      Would I need to alter the formula for it by affected by dates on a splicer

      • SpartaBI's avatar
        SpartaBI
        Community Champion
        4 years ago

        Nigel29 It will pick up any filter in the way I wrote you.

        There is no calculate their that change the filter context