How to make a DAX measure NOT to re-calculate on aggregated levels?
Results 1 to 4 of 4

Thread: How to make a DAX measure NOT to re-calculate on aggregated levels?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to make a DAX measure NOT to re-calculate on aggregated levels?

    I have a DAX measure which works perfectly on the level 0 POV in the Pivot Table but I was wondering if there is a way to make it aggregate like a regular number when filtering to top level POV (e.g. instead of looking at July or August, look at Year Total)?
    The problem is the aggregated number on the calculated column != the number if it was aggregated in the Planning system in a regular number column

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to make a DAX measure NOT to re-calculate on aggregated levels?

    You shouldn’t be using calculated columns (in my view). If you switch to measures, chances are you problems will disappear. https://exceleratorbi.com.au/calcula...-measures-dax/
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

  3. #3
    New Member
    Join Date
    Aug 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to make a DAX measure NOT to re-calculate on aggregated levels?

    Quote Originally Posted by Matt Allington View Post
    You shouldn’t be using calculated columns (in my view). If you switch to measures, chances are you problems will disappear. https://exceleratorbi.com.au/calcula...-measures-dax/
    I am using a measure

  4. #4
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to make a DAX measure NOT to re-calculate on aggregated levels?

    Quote Originally Posted by ArthurOff View Post
    The problem is the aggregated number on the calculated column != the number if it was aggregated in the Planning system in a regular number column
    Quote Originally Posted by ArthurOff View Post
    I am using a measure
    I'm happy to try to help, but you will need to provide more information
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •