Aggregate Value

[nishantr]

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

[v-xiaotang]

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

[v-xiaotang]

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.

[parry2k]

@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.⚡

[parry2k]

@nishantr do you have a relationship between these two tables? if yes, on which column? 

[TomMartens]

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]

@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]

@nishantr what is start of month column? Can you post sample data? It is not clear from screenshot?

 Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[nishantr]

Its the Month names for all the rows

[nishantr]

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