Matrix Help

[Wardy]

I am currently having an issue when adding a field to the Columns of a Matrix table.

I have simiplified the results down to see if anyone can help.

Table 1 - FactPolicyTransactions [FPT] gives me a Total of 70 Sales based on a DistinctCount of Policy.

ClassOfBusinessCode is also taken from the [FPT] 

Table 2 - contains the Class of Use from the Logical.SummaryCovernetCombined table and when added to the matrix it shows as:

The correct split should be :

Commercial Office 28

Commercial Shop 42

There is a 1:* join between the tables based on PolicyTransactionKey

Any help or pointers greatly appreciated 😇

[v-lionel-msft]

Hi @Wardy ,

How abut this?

Measure =
CALCULATE(
    DISTINCTCOUNTNOBLANK('Table'[Column]),
    ALL('Table')
)

 If it's not work, please provide sample data.

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.

[Wardy]

@v-lionel-msft thanks for taking the time to look at this. Happy to say I now have this issue resolved. 😁

[Anonymous · Accepted solution]

@Wardy  Can you try making the cardinality to bidirectional seems like you are trying to filter table (2) with table(1) attributes which is why it is giving wrong result

Regards,

Husna

[Wardy]

Thanks @Anonymous for this solution it resolved my issue. 👏👏