Forum Discussion
Matrix Help
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 😇
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
4 Replies
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
Thanks Anonymous for this solution it resolved my issue. 👏👏
Hi Wardy ,
How abut this?
Measure = CALCULATE( DISTINCTCOUNTNOBLANK('Table'[Column]), ALL('Table') )If it's not work, please provide sample data.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-lionel-msft thanks for taking the time to look at this. Happy to say I now have this issue resolved. 😁
