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 error -

This the formula that I'm using - 

Index = [weighted_float_key_service_appid_tag] + [weighted_float_savings_plan_util] + [weighted_float_key_service_reserved] + [weighted_float_savings_plan_coverage]
DAX
percentage
  • v-hjannapu's avatar
    v-hjannapu
    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.

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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.

  • maruthisp's avatar
    maruthisp
    Super User
    1 year ago

    Hi ajaymanshani ,

    Can you please try below things to fnd out the actual problem:
    1. Please check once again for all measures data types

    2. Try to recreate all the 4 measures as CALCUALTED COLUMNS and then create the final calculated column with all those 4.
    3.Try to optimize the data model.

    Above are the steps to find out what is the issue. Based on the understanding, you can debug more into measures in the approach which you are trying.

     

    Please let me know if there is any questions..

    If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

     

    Best Regards, 

    Maruthi 

    LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

    X            -  Maruthi Siva Prasad - (@MaruthiSP) / X



  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    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.

    • v-hjannapu's avatar
      v-hjannapu
      Community Support
      1 year ago

      Hi ajaymanshani ,

      Just wanted to check if you had the opportunity to review the suggestion provided?

      If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

       

      Thank You.

      Harshitha.

      • v-hjannapu's avatar
        v-hjannapu
        Community Support
        1 year ago

        Hi ajaymanshani  ,

        I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.


        Thank you