cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## La tabla que creo en power bi, el resultado total de usuarios respecto al % de usuarios calcula >100

TaulaEdats =
VAR TotalUsuarios =
CALCULATE(
DISTINCTCOUNT(Any2023[ID de usuario]),
FILTER(
Any2023,
)
)
RETURN
SUMMARIZE (
FILTER(
Any2023,
),
"Total usuaris", CALCULATE(
DISTINCTCOUNT(Any2023[ID de usuario])
)
),
"% Total",
DIVIDE (
[Total usuaris],
TotalUsuarios
) * 1
)

Edad del usuario|| Total usuaris|| % Total
 16 32 6,41% 17 40 8,02% 18 21 4,21% 19 18 3,61% 20 12 2,40% 21 12 2,40% 22 8 1,60% 23 20 4,01% 24 7 1,40% 25 12 2,40% 26 8 1,60% 27 7 1,40% 28 13 2,61% 29 13 2,61% 30 31 6,21% 31 12 2,40% 32 10 2,00% 33 7 1,40% 34 6 1,20% 35 10 2,00% 36 8 1,60% 37 4 0,80% 38 9 1,80% 39 9 1,80% 40 9 1,80% 41 10 2,00% 42 9 1,80% 43 8 1,60% 44 13 2,61% 45 14 2,81% 46 18 3,61% 47 14 2,81% 48 7 1,40% 49 17 3,41% 50 9 1,80% 51 7 1,40% 52 5 1,00% 53 7 1,40% 54 5 1,00% 55 5 1,00% 56 6 1,20% 57 3 0,60% 58 3 0,60% 59 1 0,20% 60 4 0,80% 61 2 0,40% 62 3 0,60% 63 1 0,20% 65 1 0,20% 66 1 0,20% 511 102%

El total usuarios es correcto, pero el calcul de la proporcion, lo hace sobre 499 usuarios.

Alguna idea.

Gracias

2 ACCEPTED SOLUTIONS
Super User

Hi,

I transform yours calculated column in explicit measures and now it's working properly.
See the result and measures:

Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!

Frequent Visitor

Very good !!

Thanks ...

6 REPLIES 6
Frequent Visitor

Very good !!

Thanks ...

Super User

Hi,

On the part bellow try to replace the DISTINCTCOUNT(Any2023[ID de usuario]) to [Total usuaris] and see if it solves your problem.

Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!

Frequent Visitor

No funciona, no acepta poner [Total Usuaris]

Super User

Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!

Frequent Visitor

Como comparto el archivo?

Super User

Hi,

I transform yours calculated column in explicit measures and now it's working properly.
See the result and measures:

Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!