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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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