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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sofia_Osorio_20
Regular Visitor

Power BI - Calculate the number of units produced per SKU, in the timeframe selected by the slicer

I have a problem in Power BI. I want to calculate the total number of units produced per SKU, in the time frame selected on a slicer. As you can see in the exampleExample.png

 

, I want to get different results on the quantity of products produced per SKU according to the respective month. However I don't know how to do it without a table to save the results, however a table isn't dynamic. I know that Measure is dynamic, however I don't know how to apply it in this case.

I need the total quantity produced per SKU because then I want to know how many SKUs have been produced more than 2 times, 4 times, etc. I also want to know, the total quantity of products of the SKUs that were produced more than 2 times, 4 times, etc.

Thank you in advance!

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

Please find attached the PBI file.

Ashish_Mathur_0-1695513879998.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Please find attached the PBI file.

Ashish_Mathur_0-1695513879998.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
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.

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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