cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sudhakar1000
New Member

New measure for Percentage

Hi,

I am usiing new measure for percentage, but its not appearring ,

And I am getting values

Sudhakar1000_0-1624463770555.png

But when i select the all region Total should be  like below image

Sudhakar1000_1-1624463851399.png

Instead of 71% now i am getting 342%, Can you anyone help here

 

 

 

1 ACCEPTED SOLUTION
Fowmy
Super User IV
Super User IV

@Sudhakar1000 

You can modify your Q1% measure as follows:

Q1 % = 
DIVIDE(
    SUMX( Table , Table[Q1 Achive] ),
    SUMX( Table , Table[Q1 Target] )
)
    
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn   Join my Power BI User

View solution in original post

1 REPLY 1
Fowmy
Super User IV
Super User IV

@Sudhakar1000 

You can modify your Q1% measure as follows:

Q1 % = 
DIVIDE(
    SUMX( Table , Table[Q1 Achive] ),
    SUMX( Table , Table[Q1 Target] )
)
    
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn   Join my Power BI User

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors