cancel
Showing results for
Did you mean:
Helper I

## Created mesure is wrong

Hi everyone !

On a report, I created two mesures, and the change with the filters (6 filters).

Then, I want to have a percentage, so I divide mesure1 by mesure2 :

newMesure = [mesure1]/[mesure2].

The problem is the newMesure isn't correct ! 😮

I display my mesure1 and mesure2 and the value change with the filter.

I saw, by modifying the filters that newMesure changes. But it's never the correct value ! If I do my operation on Excel, 616/11408 is not 1.34 % 😮

How can I do ? I checked the filters and nothing... Any ideas ?

Thank you very much for your help !

Tiff

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II

## Re: Created mesure is wrong

you can adjust the second measure with TREATAS/INTERSECT
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

Thank you for the kudos 🙂

Proud to be a Datanaut!

9 REPLIES 9
Helper I

## Re: Created mesure is wrong

It's really strange...

I tried with newMesure = DIVIDE(Mesure1;Mesure2;1), and the result is different from newMesure = Mesure1/Mesure2 !
However, the filters applied are the same....

Super User II

## Re: Created mesure is wrong

are you sure it's a measure and not calculated column? Calculated column could have the behaviour you describe, as it would calculate % per row and then sum, while measure would sum first and then calculate ratio

Thank you for the kudos 🙂

Proud to be a Datanaut!

Helper I

## Re: Created mesure is wrong

Hi,

Yes, I clicked on "New Mesure" above "new Column", so I'm pretty sure it's really a mesure....

Thank you for your help !

Helper I

## Re: Created mesure is wrong

Hi,

See that ? On the right, we can see it's a mesure...
On the report, it's writtent that 4384-51=4384 and 11408-616=11255....
The same for the percentage, where 51/4384 is not 1.45 % 616/11408 neither....

I don't know how to do... It is so strange ! And I'm completly stuck for the rest of my work...

Tiff

Community Support

## Re: Created mesure is wrong

HI @Tiff,

Can you please share more detail information to help us clarify your scenario?

In addition, you can also take a look at following blog about how to nested multiple measures:

Optimizing DAX expressions involving multiple measures

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Super User II

## Re: Created mesure is wrong

can you share syntax for measure 1 & measure2?

are you sure that filters for all card visuals are the same?

Thank you for the kudos 🙂

Proud to be a Datanaut!

Helper I

## Re: Created mesure is wrong

Hi everyone,

I found my problem, and I don't think I can solve it.

The mesure 1 and 2 take their data in different tables. So I have two filter for the date for example, one filter for mesure 1, the other for mesure 2. So, when I adapt the first filter, mesure 1 is correct, but not mesure 2, so the new calculated mesure is wrong. And when I adapt the second filter, mesure 1 is wrong and mesure 2 isn't, so the new calculated mesure is wrong two.
I don't see a way to do it differently.

Tiff

Super User II

## Re: Created mesure is wrong

you can adjust the second measure with TREATAS/INTERSECT
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

Thank you for the kudos 🙂

Proud to be a Datanaut!

Helper I

## Re: Created mesure is wrong

Thank you very much !

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors