Forum Discussion

ajaymanshani's avatar
ajaymanshani
Regular Visitor
1 year ago
Solved

Add %age values

I have 4 different percentage values, coming from 4 calculated measures, they are decimal numbers formatted as percentages, I am trying to sum all 4 of them but unable to and am getting the following...
DAX
percentage
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ajaymanshani,
    Thank you  for reaching out to the Microsoft fabric community forum.

    The issue you are facing with the Index measure not returning the correct total value is happening because the way DAX calculates totals for measures is different from how it processes individual rows.
    I tested it with my sample data, and it worked fine. Please find the attached Pbixand screenshot for your reference.


    If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated.
    Thank you,
    Harshitha.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
1 year ago

ajaymanshani What are the base measure formulas and how many rows of data do you have? Probably need to optimize the base measures in some way as you are running out of memory trying to compute this.