Forum Discussion
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 show the revenue gained as this year revenue if not 0.
if this condition is met, it will show the revenue gained as this year revenue if not 0.
the total at the bottom of the table visual should show me the total revenue gained. but for some reason it is just showing 0. how do i resolve this?
Rev Gains =
Rev Gains =
if(
sumx(
FILTER(
'FACT',
[fiscal_year]=year(today())-1),
[Revenue]) = 0
&&
sumx(
FILTER(
'FACT',
[fiscal_year]=year(today())
),[Revenue]) <> 0,
calculate(sum('FACT'[Revenue]),
FILTER(
'FACT',
[fiscal_year] = Year(today()))),0)
Hi, Anonymous
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.
3 Replies
- Kishore_KVN
Solution Sage
Hello Anonymous
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!! 
v-zhangtiCommunity Support
Hi, Anonymous
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.
