Forum Discussion

JasserBI's avatar
JasserBI
Frequent Visitor
2 years ago

The element from calculation group shows empty value with ALLSELECTED()

Hello,

 

I am trying to display one specific calculation group item but I am constantly receiving the same output, which is blank value. Whereas the total appears as '1':

This is the formula that is being used as a Value in the matrix:

Whereas this is the calculation element that is being used as column in the matrix:

I think that the key is in the 'ALLSELECTED()' part of the 'CALCULATE' but it seems to not work. 

 

Please I need support on this asap. Thank you very much in advance!

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    JasserBI , Grand Total will be 1, as the sum of the numerator is the same as denominator in total (for sum measure).

     

    You can use all, and that will give a difference only when something is filtered.

     

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.