Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Divide Function Measure in Matrix Percentage Overall Total Incorrect

I have reviewed numerous topics in this forum, but haven't found one that fits my issue exactly.  I have two measures that I've created to use with the DIVIDE function to obtain the overall % total. ...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I have figured out what I was doing wrong. The problem was MeasureB. I have fixed MeasureB and it looks like this: 

    CALCULATE(
               SUM('Revenue_Actuals Plan'[Plan(BG)]),
              FILTER('Calendar',
              'Calendar'[Date] <= TODAY() &&
              YEAR('Calendar'[Date]) <> 2022

              )
    )
    Now MeasureC is working perfectly!!!
     I hope this helps someone else in the future. 
    Please close this question. 
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I have figured out what I was doing wrong. The problem was MeasureB. I have fixed MeasureB and it looks like this: 

CALCULATE(
           SUM('Revenue_Actuals Plan'[Plan(BG)]),
          FILTER('Calendar',
          'Calendar'[Date] <= TODAY() &&
          YEAR('Calendar'[Date]) <> 2022

          )
)
Now MeasureC is working perfectly!!!
 I hope this helps someone else in the future. 
Please close this question.