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 "total" row. 

 

cod_cliente is from Codigo_sico_sap table

COD.ALMACEN es from Base_Legal_Conductor table

Value is from Foperau table 

 - Relative Total = CALCULATE([value],ALLEXCEPT(Base_Legal_Condunctor,Base_Legal_Condunctor[COD. CLIENTE]),ALLEXCEPT(Codigo_Sico_Sap,Codigo_Sico_Sap[cod_sico]))

- Value = SUM(Foperau[saldo_usd])

 

 

 

 

 

 

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 )
)

2 Replies