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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Target Sales Percentage based on Store ID in DAX

Hello All,

I have the below data set for sales for which I am trying to get a percentage of sales in measure.

 

Store IDSales DateDaily salesTotal Employees
1011/1/202159
1011/1/202189
1011/1/2021109
1021/1/2021711
1021/1/2021511
1021/1/20211111
1021/1/2021811
1021/1/20211211

 

I want to have Perctenage KPI which calculates Store Total Sales / Total Employees. For example, for Store 101 my measure will return (5+8+10)/9 = 2.55 so on and so forth...

By default, I would like to have a value that returns data for all stores. In above example. All the sales will be summed (66) and then divided by (9+11) = 20 and the result should show as 3.3

Any guidance will be helpful.

Thanks,


 

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Try a measure like

divide(sum(Table[sales]), sumx(values(Table[Store ID]), calculate(max(Table[Total Employees]))))

 

or try like

averageX(summarize(Table, Table[Store ID] , "_1", sum(Table[sales]) , "_2",calculate(Max(Table[Total Employees]))), divide([_1],[_2]))

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors