Amazon Measures

Amazon Dashboard Creation in 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.

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)