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 CFY USD]),PREVIOUSMONTH('Calendar'[Date]))
RETURN
IF(SELECTEDVALUE('Calendar'[Month Diff])=0,V1,BLANK())

 

 

 

 

 

Any ideas?

 

Thanks

 

 

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

     

     

1 Reply

  • 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