Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    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.

dadb25's avatar
dadb25
Icon for Helper I rankHelper I
2 years ago

Hi Damiax,

You can use this measure :

Measure =
SUM ( Feuil1[Val1] )
    - ( SUMX ( 'Feuil1', 'Feuil1'[Percentage] * 'Feuil1'[Val2] ) )
 
Hope it helps.
Did I answer your question? Mark my post as a solution!
 
Regards

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi dadb25 , I've tried your solution but I got a tottaly wrong number.

My Feuil1[Val1] is a distinct count measure coming from a column of table A, percentage is a column of Table B and Feuil1[Val2] is another distinct count measure coming from a column of table C.

I don't know whether this could be a problem