Amazon Measures for Power BI

Here are some Power BI measures created using DAX to generate KPI cards and options for unit and sale amounts. With these DAX codes, you can filter data and create KPI cards to review metrics like units sold, returns count, and more. A complete tutorial is available on YouTube, which you can find by searching for “The Developer Amazon Dashboard” or by visiting our YouTube section.

Download Dashboard

This Power BI file is part of a full YouTube tutorial where you’ll learn how to upload data, clean and transform it, and write DAX measures to build a fully functional Amazon Sales Dashboard. The measures included in this file are the exact ones used in the tutorial to help you understand and replicate each step with ease.

Whether you’re a beginner or an aspiring data analyst, this project will guide you through:

• Uploading and connecting your dataset in Power BI

• Data cleaning and transformation using Power Query

• Creating insightful DAX measures

• Building professional-level dashboards with real Amazon sales visuals

👉 Watch the full tutorial on YouTube and follow along step by step.
This resource is created to help learners, students, and professionals master Power BI through real-world examples.
Here is link o Tutorial

Create Sales option.

Sale_Option = 
 DataTable("Type", STRING,  
            "Name", STRING  
               ,{  
                        {"1","Sales"},
                        {"2","Units"}
                    
                }  
           )  

Icon Link =

https://i.postimg.cc/g0BwRqDN/check-2.png

Overall Sale

All_Sale = CALCULATE([Sale_Units],ALL('amazon-fashion'[Category]))

Sales units and amount

Sale_Units = var selecting = SELECTEDVALUE(Sale_Option[Type])

var _units =SUM(Amazon[Qty])
var _sale = SUM(Amazon[Total_Ammount])

return IF(selecting="1",_sale,_units)

Return Units

Return_Units = var val= CALCULATE([Sale_Units],CONTAINSSTRING(Amazon[Status],"Return"))
return IF(ISBLANK(val),0,val)

Reviews

Reviews = var val = COUNT('amazon-fashion'[no__of_reviews])
RETURN IF(ISBLANK(val),0,val)