Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
problem statement: my actuals. measure in the table shows cumulative value, but when i place the same measure on the card, i get that individual value of the month, as you can see in Feb its 50M as cumulative value and in card it shows as 32M
this is my measure for cumulative value
this is my measure for month on month Actuals
Solved! Go to Solution.
Hi @vjnvinod , I tried to replicate your problem statement and below formula is working for me.
Just change the ALLSELECTED to ALL in your case.
Hi, @vjnvinod
As @AnkitaaMishra said, you can try the following formula.
Actual. =
IF([Actuals]>0,
CALCULATE([Actuals],
FILTER( ALL('GroupOPEXCAPEX'),
'GroupOPEXCAPEX'[DateColumn] <= MAX('GroupOPEXCAPEX'[DateColumn]) &&
'GroupOPEXCAPEX'[Actual/Budget] = "Actuals"
)),BLANK()
)
Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @vjnvinod , I tried to replicate your problem statement and below formula is working for me.
Just change the ALLSELECTED to ALL in your case.
Hi @vjnvinod, I believe that the complexity of your case comes from the use of ALLSELECTED as a table function
This should help 🙂
Hi @vjnvinod, Please try this:
Total Cumulative Value =
CALCULATE(
SUMX(
ALLSELECTED('GroupOPEXCAPEX'[DateColumn]),
[Actuals]
),
'GroupOPEXCAPEX'[Actual/Budget] = "Actuals"
)
Hey , @vjnvinod please try this
Actuals Combined =
IF(
ISINSCOPE('GroupOPEXCAPEX'[DateColumn]),
-- Cumulative logic for table rows
IF(
[Actuals] > 0,
CALCULATE(
[Actuals],
FILTER(
ALLSELECTED('GroupOPEXCAPEX'),
'GroupOPEXCAPEX'[DateColumn] <= MAX('GroupOPEXCAPEX'[DateColumn]) &&
'GroupOPEXCAPEX'[Actual/Budget] = "Actuals"
)
),
BLANK()
),
-- Monthly value for card or other non-date visuals
CALCULATE(
SUM('GroupOPEXCAPEX'[Value]),
'GroupOPEXCAPEX'[Actual/Budget] = "Actuals"
)
)
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |