Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average Total

Hi,   I have a column which I have to display as Average values for the calculation to work.   This however, then displays the total as average which I cant have.   Is there any way I can remov...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    Anonymous 

     

    Make sure that the column you include in your ISINSCOPE measure is the same as the one you are using in your visual. (ie, if the rows are from a dim table, you must use that same column in  the ISINSCOPE measure)

     

    See this example:

    Rows for Item from Tabe A (see measure)

     

    The measures are:

     

     

    Average Actuals = AVERAGE('Table A'[Actuals]) +0

     

     

    And the one used in the "Average without totals" table (NOTE: the "Item" in rows is from Table A = same as measure):

     

     

    Average without totals = IF(ISINSCOPE('Table A'[Item]); [Average Actuals]; BLANK())

     

     

    If however I use a column from a different table as  rows, I get blank: ("Item" in rows from Table B)

     

    Does that solve the problem?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amitchandak,

 

Its 

= AVERAGE(vwtest[Points])+0
amitchandak's avatar
amitchandak
Super User
6 years ago

Seems fine, unless you want to ignore 0. What is the expected result and what you are getting

 

AVERAGEX(vwtest,if(vwtest[Points]=0, blank(),vwtestPoints]))+0

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak,

     

    Its not the calculation thats the problem, its the displaying of the total (99) which is averaging all of the numbers which isnt needed, and I'm not sure whether theres a way around it.

     

    Thanks in advance

     

    Liam