Daily Sales Plan Total By Filtered Date

[VazhaPBI]

Hello Guys,

I divided Monthly Sales Budget by monthly working days, but now total doesnt show sum of i, now my situation is seen on screen.

this is Daily budget calculation:

Daily Budget2 = IF(ISFILTERED('DatesTable - All Reports'[Date]),

            CALCULATE(

                SUM('Sales Plan Data - All Reports'[Daily Budget]),

                TREATAS(VALUES('DatesTable - All Reports'[MonthAndYear2]),'Sales Plan Data - All Reports'[MonthAndYear])

                ), [Total Budget])
Total Budget Calculation:

Total Budget = CALCULATE(

                    SUM('Sales Plan Data - All Reports'[Budget Amount]),

                    TREATAS(VALUES('DatesTable - All Reports'[MonthAndYear2]),'Sales Plan Data - All Reports'[MonthAndYear])

                )

[RicoZhou · Accepted solution]

Hi @VazhaPBI ,

 I think you can create sum based on [Daily Budget2] table.

New Daily Budget2 =
SUMX ( VALUES ( 'TableName'[Date] ), [Daily Budget2] )

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.