Forum Discussion
How to create a static measure in chart visual
Hello everyone. I'm trying to create a measure that isolates the value of another measure for a given month, and then replicates in all the rows, for all the other months. To visualize, I have an...
Hello,
You have to remove the filters for each month then apply August as a filter.
Value2 = CALCULATE([Value], REMOVEFILTERS([Month]), [Month] = "August")
Image 1 has every month with value = MonthNumber then Image 2 is the second measure with all of them equal to 8
You have to remove the filters for each month then apply August as a filter.
Value2 = CALCULATE([Value], REMOVEFILTERS([Month]), [Month] = "August")
Image 1 has every month with value = MonthNumber then Image 2 is the second measure with all of them equal to 8