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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Raul
Post Patron
Post Patron

New Measure to Divide two existing columns

Hello,

I need your help for a new measure that I have to create.

I have a measure like this: M1 = CALCULATE(COUNT(matrix[registerId]);matrix[columnA]) with integer number format

And another measure like this: M2 =  CALCULATE(COUNT(matrix[registerId]);matrix[columnA];matrix[question]="P1")  with integer number format

 

If I represent the two measure in two graphics, I have this:

For M1 M1.JPG

For M2 M2.JPG

 

When I create de new measure M3 = DIVIDE([M1];[M2];0) with percentage format

The result in a graphic is this: M3.JPG

 

When the correct result would have to be this:  83%         76%         85%           91%          77%

 

What is the problem?
What do I do wrong?

Thanks.

1 ACCEPTED SOLUTION

Hello @v-shex-msft.

Thanks for answering me but the problem is solved. There was a mistake on my part.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @Raul,

 

Can you share some sample data to test?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hello @v-shex-msft.

Thanks for answering me but the problem is solved. There was a mistake on my part.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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