SUM Grand TOTAL

[cristianml]

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

[cristianml · Accepted solution]

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