Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Rocky_PBI
Regular Visitor

Same count value of ID and same summarised value of Quantity

1705147506345771353944931260229.jpg

In Power BI Report, I'm using two tables, Table1 and Table2. I extract the date column from Table1 and the Package ID and Package quantity from Table2. The date column represents the last 30 days, and I'm counting Package IDs and summing Package quantities. However, after running the report, I'm getting the same Package ID and Package quantity for all dates. How can I resolve this issue? Please help on this... Your valuable answer. Will my solution. I am attaching screen shot of your reference. That screenshot is sample one. 

IMG20240113171732_BURST001.jpg

1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.