Incorrect sum of Row Total

[tqn626]

I've been trying to figure out this issue for days. I'm not sure if it a relationship issue or a formula issue.

When I select each multiple selections it will give me the correct number. When selecting all it will give me the incorrect number.

Selecting 2 entries

Selecting all

The formula

Total Active Store Count =
CALCULATE (
    COUNTROWS ( SUMMARIZE ( Dim_v_ip_outs, Dim_v_ip_outs[vp_id] ) ),
    Dim_v_ip_outs[status] = "A"
)

[v-yalanwu-msft]

Hi, @tqn626 ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @tqn626 ;

Try the following formula,

Total Active Store Count =
COUNTROWS ( SUMMARIZE ( FILTER ( 'Dim_v_ip_outs', [status] = "A" ), [vp_id] ) )

your total is incorrect because of relationship reasons, but it should be solved through the formula, but because the information you provided is a little little, I cannot reproduce, can you make a simple file to remove sensitive information, keep the structure consistent with the source data? In this way, sensitive information can be avoided, and your problem can be solved better .

Looking forward your reply!

Best Regards,
Community Support Team_ Yalan Wu

[Ashish_Mathur]

Hi,

Does this work?

Total Active Store Count = CALCULATE(DISTINCTCOUNT(Dim_v_ip_outs[vp_id]),Dim_v_ip_outs[status] = "A")

[tqn626]

Still getting same issue.

[Ashish_Mathur]

Hi,

I cannot help without getting access to your PBI file.

[tqn626]

Here the 3 connectors. I believe the main issue is that Voxref doesn't contain all combinations and that is by design from the datasource i'm getting it from.

VOXref

V_Ip_Out

Dim_Dist

How they're connected