Forum Discussion
hama21
Helper I
Helper IDifference between date.[month] and date.[year]
Hello everyone, I have a table in my report where I use two measures that are as follows: measure c = DIVIDE((SUM('Table[Value A])*12),SUM('Table'[Value B])) and measure to calculate the ...
Greg_Deckler
Community Champion
Community Championhama21 Well, the reason is that you are taking an average across either 2 rows (Year) or 12 rows (Month). It is also possible that VALUES is returning a blank row and that might also throw some things off. I think that your formula would be much more clear and more flexible if you did not use the auto-time intelligence stuff which has the potential to cause issues as well as use SUMMARIZE or DISTINCT versus VALUES. Seriously, don't use VALUES: https://youtu.be/vOUdKXZpmSc
hama21Helper I
Helper IHow do you recommend my formula? I'm watching the video right now. Thanks for the answer Greg_Deckler