Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculation group not working as expected

Hi all I am trying to do something very simple with calculation groups, but I can't figure out why it isn't working. So I have a calculation group with calculation item Test. The logic is as follo...
Need Help
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    Hi Anonymous 

    Calculation items only have effect when applied to measure references, not arbitrary expressions.

    See this SQLBI article for a good discussion of this.

     

    So if you instead created a measure

     

    One = 1

     

    then this version of TestCalcGroup which applies the calculation item Test to the measure [One] would return 1001:

     

    TestCalcGroup =
CALCULATE (
    [One],
    'Calculation group'[Calculation group column]= 'Test'
)

     

     

    Does this help in your particular case?

     

    Regards

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 

Calculation items only have effect when applied to measure references, not arbitrary expressions.

See this SQLBI article for a good discussion of this.

 

So if you instead created a measure

 

One = 1

 

then this version of TestCalcGroup which applies the calculation item Test to the measure [One] would return 1001:

 

TestCalcGroup =
CALCULATE (
    [One],
    'Calculation group'[Calculation group column]= 'Test'
)

 

 

Does this help in your particular case?

 

Regards