What sort of calculation is this?

[harrinho]

Hi everyone. Have come across with a measure which I need to replicate but I don't know how. What sort of calcuation is the attached? 

[v-yulgu-msft · Accepted solution]

Hi @harrinho,

This is a Key Performance Indicators (KPIs) in Power Pivot.

Please refer to below steps to replicate this KPI in your .pbix file.

1.Create a PowerPivot data model.

1) Create some sample data in Excel worksheet. Add it to Table.

2) Add table to Data Model

3) In PowerPivot, create a simple measure, then, create KPI based on this measure. Save all these changes.

4) In worksheet, create a table visual, add above measure into visual. 

2. Import above PowerPivot model into Power BI desktop. (File->Import->Excel workbook contents)

   

Reference: Create a KPI in Power Pivot for Excel – Tutorial

Best regards,

Yuliana Gu

[freder1ck]

It's a KPI. Key Performance Indicator. 

This is a pretty good intro to how KPIs work: 
https://www.sqlchick.com/entries/2010/10/10/display-of-ssas-kpi-indicators-in-excel.html

Fred

[harrinho]

Thanks @freder1ck will take a look