Forum Discussion
Solved
measure does not work
I have two measures to calcuate the score last year and this year which shown in above image(last year1 and this year1) , but the last year measure goes wrong and I can't figure out why. ...
henry24007 , The measures seem fine. Make sure year table is joining with this table and 1 - Many single direction join from Year to this table.
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
henry24007 , The measures seem fine. Make sure year table is joining with this table and 1 - Many single direction join from Year to this table.
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I solved it. it seems like my relationship line is so messy that it affected the measure. anyway thanks for your help again