Forum Discussion

nishantr's avatar
nishantr
Frequent Visitor
4 years ago

Aggregate Value

Where am I going wrong ? I want to filter the quantity sold field month wise but its showing me an aggregate value.

 

Need Help

9 Replies

      • nishantr's avatar
        nishantr
        Frequent Visitor
        4 years ago

        So everytime I am adding the quantity sold into the value field its giving me a aggregate number and not month wise

  • TomMartens's avatar
    TomMartens
    Super User
    4 years ago

    Hey nishantr ,

     

    I assume that the Quantity sold and the Start of Month column are from two different tables and that both tables are related by a date column. My 2nd assumption is that one of the columns contains a time part. Removing the timepart (changing the data type not just the format) can resolve the issue.

     

    If not, provide more information about the tables that are hosting the columns you are using in your visual.

     

    Regards,

    Tom

    • nishantr's avatar
      nishantr
      Frequent Visitor
      4 years ago

      parry2k TomMartens  the tables do have a relationship , its between Date and transaction date ,also used an inactive relationship . I feel its because of the data type but i checked everything looks correct.

       

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    nishantr can you make sure the date column in your transaction table doesn't have a time portion in it, is it a date/time column or just a date? Can you share the preview of transaction date data in Power Query?

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

     

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi nishantr 

    This error is because visual failed to get the start of month, and Quantity sold is an aggregate value,

    could you share your sample file? you can remove sensitive information and replace it with fake data. I'll test it later.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

     

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi nishantr 

    Have you solved this problem? If yes, to help others find answer faster, could you kindly accept the answer helpful as the solution (or kindly share your solution to improve Power BI).
    Really appreciate!


    Best Regards,
    Community Support Team _Tang