Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Relative Total

Hi everyone, I want to get a % of a relative total of a category. Things work fine until total since I would like the last column to be 100% and I like to see Relative total to be 17,580,000 in the ...
Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

     

    I'll give you a quick hint that might save your bacon one day 🙂 Please do not create models with 1-to-1 relationships between tables. Such tables are in fact one and the same table and data from them should be consolidated into a single table. If you do consolidate data, your model will suddenly become much simpler and easier to code against.

     

    This measure could do what you want:

     

    [measure] =
CALCULATE(
    [Value],
    ALLSELECTED( Base_Legal_Condunctor )
)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

I'll give you a quick hint that might save your bacon one day 🙂 Please do not create models with 1-to-1 relationships between tables. Such tables are in fact one and the same table and data from them should be consolidated into a single table. If you do consolidate data, your model will suddenly become much simpler and easier to code against.

 

This measure could do what you want:

 

[measure] =
CALCULATE(
    [Value],
    ALLSELECTED( Base_Legal_Condunctor )
)