Forum Discussion
Created mesure is wrong
you can adjust the second measure with TREATAS/INTERSECT
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
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
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 !
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...Thannk you for your help,
Tiff
HI Tiff,
Can you please share more detail information to help us clarify your scenario?
How to Get Your Question Answered Quickly
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
can you share syntax for measure 1 & measure2?
are you sure that filters for all card visuals are the same?