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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Bhavana_HR
Frequent Visitor

KPI - Filter based on region

Hi,

 

I would like to get help on below scenario,

I have 3 regions,

Region

America

Asia

Europe

 

and below are the KPI's :

 

 

 

plant1

plant2

plant3

Total_America

KPI1

0.7

0.941

0.9236

2.5646

KPI2

0.616

0.912

0.837

0.080425

KPI3

80

116.95

134.8

331.75

KPI4

0.023939

0.034996

0.040337

100%

KPI5

 

 

 

 

 Here i would like to calculate the value for KPI5 using the below formula

Formula : 

Total(KPI2) = 0.616*0.023939+0.912*0.034996+0.837*0.040337

KPI5 = (KPI2-KPI1)*KPI3 / Total(KPI2) 

The total of KPI2 should change accordingly when the specific region in selected in the slicer

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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