Forum Discussion
vjnvinod
Impactful Individual
Impactful IndividualTotal on the table is not correct
Dax issue below is my dax Cumulative Actual + Forecast = IF( CALCULATE( SUM('GroupOPEXCAPEX'[Value]), 'GroupOPEXCAPEX'[Actual/Budget] = "Actuals" ) > 0, -- Use...
Please refer to the screenshot
Ashish_Mathur
Super User
Super UserHi,
The very first blunder is that you do not have a Calendar Table. Anyways, this measure pattern should work
Measure = SUMX(Calendar[Month name],[Cumulative Actual + Forecast])
In the visual, the Year and Month name fields should be dragged from the Calendar Table. In your existing meaure as well, changes will have to be made but with the information which you have shared, this is the max i can help you.