First import the two excel files

DAX Orders.xlsx

DAX Customers.xlsx

Both files are provied by Rishabh Mishra, thank you sir ji

I am going to honeymoon you keep learning Python_enhanced.png

Get Data > Excel Workbook > Select File > Load

Copy of Copy of class Car def init(self, brand, model) self.brand = brand self.model = model.png

1. COUNT (using COUNT)

Now I want to know about total orders (Orders Count)

Right click on order table > New Measure

Copy of Copy of class Car def init(self, brand, model) self.brand = brand self.model = model (1).png

Now in the formula bar,