cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lexey Regular Visitor
Regular Visitor

comparison with the standard

Hello everyone! Please help in solving following tasks:

I want to display column 43 and 44, the percentage value from the column 45 in order to be able to compare

 

Screenshot_6.jpg

 

https://drive.google.com/file/d/1h0s3Dunq0liw8BKbpDK0PjeujpncBHgQ/view?usp=sharing

6 REPLIES 6
Lexey Regular Visitor
Regular Visitor

Re: comparison with the standard

the link my model, I do not understand how to attach the file

Lexey Regular Visitor
Regular Visitor

Re: comparison with the standard

can't anybody help me?

Super User
Super User

Re: comparison with the standard

Hi,

 

Your question is not clear.  What exact numbers/percentage are you expecting?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Lexey Regular Visitor
Regular Visitor

Re: comparison with the standard

as me in every building point to the percentage of 45 the building
so I could compare them later

Lexey Regular Visitor
Regular Visitor

Re: comparison with the standard

[percentage] is the distribution of work costs


the distribution of building 45 is the standard


I need to compare the percentage of each building with the standard (45)

 

really need help

Super User
Super User

Re: comparison with the standard

Hi,

 

Write this measure

 

=[total cost]/CALCULATE([total cost],'fact'[building]=45)

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)