Forum Discussion
Solved
Matrix Visual Total Wrong
Hello Friends, Can you help me on this issue. I have 2 measures actuals and forecast and 2 columns cost and fiscal year. I want to visual a matrix with this data with a condition for fiscal year 2024...
I got the answer
Result =var a = CALCULATE([Actuals],FILTER('Calendar','Calendar'[Fiscal Year]=2024))
var b = CALCULATE([Forecsst],FILTER('Calendar','Calendar'[Fiscal Year]<>2024))
var c = a+b
return c
I got the answer
Result =
var a = CALCULATE([Actuals],FILTER('Calendar','Calendar'[Fiscal Year]=2024))
var b = CALCULATE([Forecsst],FILTER('Calendar','Calendar'[Fiscal Year]<>2024))
var c = a+b
return c