need help in creating measure in power bi.

[soodpy]

i have national sales data in excel, with RM name, date and products.

i want to create a card showing attachment rate (comparison of two products).

Like if there is a sale of 10 rail tickets as compare of 100 total tickets. Then it should show 10%.

All slicers should work as it is like slicer as per RM name, Date and location.

[jennratten]

Hello @soodpy - this should get you started.  I have included a sample pbix which demonstrates the general DAX pattern to calculate percent of a total.  I have also included some helpful links below where you can go to learn more.

https://learn.microsoft.com/en-us/training/paths/model-data-power-bi/ 

https://learn.microsoft.com/en-us/training/paths/build-power-bi-visuals-reports/