Forum Discussion

MBreden's avatar
MBreden
Icon for Helper I rankHelper I
3 years ago

Calculations within categories

Hi all, In my PBI table, values are calculated by category and retailer. Value = SUM('Data'[TradeTerm Value]) 'Dim Retailer'[Retailer ID] 'Dim Category'[Main]   I would now like to calcul...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi MBreden 

[Main] and measure [TT Value], what are they? How are they related with the columns in your original post?

MBreden's avatar
MBreden
Icon for Helper I rankHelper I
3 years ago

Hi FreemanZ,

I could not implement your 2nd suggestion at all.


My data model looks like this:

For better understanding, I have created a shortened example file.