Problem with DAX measures - total

Anonymous To ensure that the total is calculated correctly, you can use the SUMX function to iterate over the table and sum the results. Here is how you can modify your measures:

Broj kupaca 0-5 =
VAR _tabela = ADDCOLUMNS(
SUMMARIZE(
OTP,
OTP[Šifra kupca]
),
"@Promet",[Promet],
"@UkupanPromet",CALCULATE([Promet],REMOVEFILTERS(OTP[Šifra kupca]))
)

VAR _ucesce = ADDCOLUMNS(
_tabela,
"@Ucesce",DIVIDE([@Promet],[@UkupanPromet])
)

VAR _filtrirano = FILTER(
_ucesce,
[@Ucesce] >=0.00 && [@Ucesce]<=0.05
)

VAR _brojKupaca = COUNTROWS(_filtrirano)

RETURN
IF(
HASONEVALUE(OTP[Šifra kupca]),
_brojKupaca,
SUMX(
VALUES(OTP[Šifra kupca]),
CALCULATE(_brojKupaca)
)
)

DAX
Broj kupaca 5-10 =
VAR _tabela = ADDCOLUMNS(
SUMMARIZE(
OTP,
OTP[Šifra kupca]
),
"@Promet",[Promet],
"@UkupanPromet",CALCULATE([Promet],REMOVEFILTERS(OTP[Šifra kupca]))
)

VAR _ucesce = ADDCOLUMNS(
_tabela,
"@Ucesce",DIVIDE([@Promet],[@UkupanPromet])
)

VAR _filtrirano = FILTER(
_ucesce,
[@Ucesce] >=0.051 && [@Ucesce]<=0.10
)

VAR _brojKupaca = COUNTROWS(_filtrirano)

RETURN
IF(
HASONEVALUE(OTP[Šifra kupca]),
_brojKupaca,
SUMX(
VALUES(OTP[Šifra kupca]),
CALCULATE(_brojKupaca)
)
)