wrong count of SSAS measure using import vs live connection

[Anonymous]

Hello all,

I need make changes to existing report( which is connected as Import query to SSAS model). While getting count of one of the measure, it is showing wrong values.

I have checked the same by creating a live connection where I am gettinig correct values, also correct values when connected to excel.

Measure used (using Import query)

Measure in SSAS model - Service[Transaction]

Count1 = CALCULATE( Count (Service[ Transaction]), USERELATIONSHIP(Calendar[Date], Service[OpeningDate]))

Any pointers will be helpful?

[v-lionel-msft]

Hi @Anonymous ,

USERELATIONSHIP(Calendar[Date], Service[OpeningDate]

You check if the table relationship in import mode is different from the model in SSAS.

It may be that the table model in import mode has changed.

Maybe you can refer to @MFelix 's formula.

Best regards,
Lionel Chen

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

[Anonymous]

Thanks for replying.

I tried using CountX but it gave same result as Count.

Regarding table relationship, I have there is calendar table created which is connected Opening date to Service table. This is inactive relationship. I have added other measure for which it is showing correct total.

[v-lionel-msft]

Hi @Anonymous ,

Aggregating measures can easily lead to incorrect results because the measure is a dynamic value.
You may need to analyze the context of the measure before counting.

Best regards,
Lionel Chen

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

[MFelix]

Hi @Anonymous ,

Believe that you need to use a COUNTX that will count the number of measures you are having.

Something similar to:

Count1 =  COUNTX(Table, Service[Transaction])