Calculate total and leave it unchanged / Calcular total y que no se modifique

[Anonymous]

Good morning, I hope someone can help me.

What I am looking to do is how I can calculate the total value and that when selecting a value from the table that total value is not modified, but only the total of the column is printed regardless of whether I select a value from the table.

Muy buenos dias , espero que alguien me pueda ayuda.

Lo que busco hacer es como puedo calcular el valor total y que al seleccionar un valor de la tabla no se me modifique ese valor total, si no que solo me imprima el total de la columna sin importar que seleccione un valor de la tabla.

[SpartaBI · Accepted solution]

@Anonymous 
MEASURE = CALCULATE(COUNT('Consilidado Pedientes'[Numero]), REMOVEFILTERS('Consilidado Pedientes')

Showcase Report – Contoso By SpartaBI

      

[Anonymous]

Hello, thank you very much for answering my question, but even when selecting a data from the column the total value is not fixed, if not it is modified.

Total de Consolidados = CALCULATE(COUNT('Consolidado Pendientes'[Numero]), REMOVEFILTERS('Consolidado Pendientes'[Numero]))

The idea is that no matter what I select in the table, it always shows me the total

[SpartaBI]

@Anonymous You didn't write the formula exactly as I written 🙂 Take a look again on what I put inside the removefilters (the entire table).

[Anonymous]

Incredible, you're right, thank you very much have a great day

[SpartaBI]

@Anonymous my pleasure 🙂
Check out my showcase report - got some high level stuff there.
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂