Forum Discussion
Solved
Measure placed in Table visual not showing total
i have this code that i will like to calculate the revenue earned this year if the particular name did not have any revenue last year but have revenue this year. if this condition is met, it will...
Hi, learningOh
You can try the following methods. Add a new measure:
Measure = Var _table=SUMMARIZE('FACT','FACT'[Name],"Value",[Rev Gains]) Return SUMX(_table,[Value])Is this the result you expect?
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.
Kishore_KVN
Solution Sage
Solution SageHello learningOh
Please use SUMX inside Calculate function as well to get the total matching.
Rev Gains =
if(
sumx(
FILTER(
'FACT',
[fiscal_year]=year(today())-1),
[Revenue]) = 0
&&
sumx(
FILTER(
'FACT',
[fiscal_year]=year(today())
),[Revenue]) <> 0,
calculate(sumx('FACT','FACT'[Revenue]),
FILTER(
'FACT',
[fiscal_year] = Year(today()))),0)
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Thank you for helping me on this.
i have changed to the same formula that you provided. but the result is the same. the table total is still missing.