Relative Total

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Greg_Deckler]

@Anonymous This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907