Forum Discussion

cristianml's avatar
cristianml
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

SUM Grand TOTAL

Hi, i need to SUM the 472,790,67  to the GRAND TOTAL (marked in RED) so I can DIVIDE it for a CARD VISUAL    See measure :   Revenue Previous Month = VAR V1 = CALCULATE(SUM('Rev CCI'[REV MTD C...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • cristianml's avatar
    cristianml
    3 years ago

    Solved with the following DAX:

     

    Revenue Previous Month =
    VAR V1 = SUMX(VALUES('Calendar'[Date]),CALCULATE(IF(SELECTEDVALUE('Calendar'[Month Diff])=0,CALCULATE(SUM('Rev CCI'[REV MTD CFY USD]),PREVIOUSMONTH('Calendar'[Date])))))
    RETURN
    V1

     

     

cristianml's avatar
cristianml
Icon for Post Prodigy rankPost Prodigy
3 years ago

Solved with the following DAX:

 

Revenue Previous Month =
VAR V1 = SUMX(VALUES('Calendar'[Date]),CALCULATE(IF(SELECTEDVALUE('Calendar'[Month Diff])=0,CALCULATE(SUM('Rev CCI'[REV MTD CFY USD]),PREVIOUSMONTH('Calendar'[Date])))))
RETURN
V1