Forum Discussion

Wardy's avatar
Wardy
Frequent Visitor
5 years ago
Solved

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 m...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

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's avatar
Wardy
Frequent Visitor
5 years ago

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