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
pbiforum123
Post Patron
Post Patron

How to create several independent calculations over different metrics?

How can i create the below table which is highlighted below. If you refer the screen shot each cell using different formula to fetch the value from above pivot table as shown in the screen shot. 

 

The first table that you see in the screen shot is already been created in power bi using group by. Now I would want to create the 2nd table in power bi. 

 

Please help me how can i create the 2nd table in power bi when the formula varies for each cell. 

 

I cannot the sample PBI as my organization doesn't allow me to share it in one drive. 

 

 

 

4 REPLIES 4
Greg_Deckler
Super User
Super User

I can't see where the values in the 2nd table are coming from. The numbers do not seem to match your first table.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hey @Greg_Deckler  Any update on this please? I am yet to find the solution for this. Please let me know if you know the solution for this.

Going to need more information. Particularly going to need sample source data and formulas that recreate the problem. In text, not images. And going to need the desired output from that sample data.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Thanks for your response Greg!

 

It is coming up from first table only. You were not able to see that since it is present in the screenshot but it is available in the actual data.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.