Forum Discussion
Incorrect Total in table and KPI Card
Hi Everybody, I have a problem with showing the correct number reported by my report according to one column. Sorry for hiding data label, but we are working in a production environment...
Hi, Anonymous
You can try the following methods.
[Value1] and [Value2] are measures.Measure1 = [Value1]-AVERAGEX('Table B',[Percent])*[Value2]Measure2 = Var _table=SUMMARIZE('Table A','Table A'[Type],'Table A'[Month],"Result",[Measure1]) Var _total=SUMX(_table,[Result]) Return IF(HASONEVALUE('Table A'[Month]),[Measure1],_total)Is this the result you expect? Please see the attached document.
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.
v-zhangti
Community Support
Community SupportHi, Anonymous
You can try the following methods.
[Value1] and [Value2] are measures.
Measure1 = [Value1]-AVERAGEX('Table B',[Percent])*[Value2]Measure2 =
Var _table=SUMMARIZE('Table A','Table A'[Type],'Table A'[Month],"Result",[Measure1])
Var _total=SUMX(_table,[Result])
Return
IF(HASONEVALUE('Table A'[Month]),[Measure1],_total)
Is this the result you expect? Please see the attached document.
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.