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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Kiran98480
Frequent Visitor

Help with the DAX formula from detailed kpi value to summarized data

From report 1(detailed report) there is a kpi already in place performance%,  now i want a kpi for report 2 at summarized level.
want to see the percentage at sold to and store level, by doing an average on performance%.
Can you help me with the formulae. 

Note : Performance% is a measure

@amitchandak

 

 

Report1   
Sold-ToStore nameMaterialPerformance%
BBBBBB AMM1100%
BBBBBB AMM2100%
BBBBBB AMM386%
BBBBBB AMM486%
BBBBBB AMM574%
BBBBBB AMM640%
BBBBBB AMM723%
BBBBBB AMM814%
BBBBBB AMM90%
BBBBBB AMM100%
  AVG52%
JBJB HM180%
JBJB HM290%
  avg85%
    
Report 2   
Sold-ToStore namePerformance % 
BBBBBB AM52 
JBJB H85 
1 ACCEPTED SOLUTION
v-jialluo-msft
Community Support
Community Support

Hi @Kiran98480 ,

 

Please follow these steps:

(1) Create a new measure

AVG =

DIVIDE (
    SUM ( 'Table'[Performance%] ), COUNT ( 'Table'[Store name] )
)

(2)Final output

vjialluomsft_0-1669966432714.png

 

Since I don't have specific sales data, I use measures as attribute columns, and you can replace them with sales columns yourself.

 

Best Regards,

Gallen Luo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-jialluo-msft
Community Support
Community Support

Hi @Kiran98480 ,

 

Please follow these steps:

(1) Create a new measure

AVG =

DIVIDE (
    SUM ( 'Table'[Performance%] ), COUNT ( 'Table'[Store name] )
)

(2)Final output

vjialluomsft_0-1669966432714.png

 

Since I don't have specific sales data, I use measures as attribute columns, and you can replace them with sales columns yourself.

 

Best Regards,

Gallen Luo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.