Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate Occurrence

Hello ,   I am looking for some help around the solution for below.   Table A(column 1)   Table B(Column 2)     1                               Tom 1                               Harry 1     ...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Anonymous ,
    According to your requirements, the table relationships in the data model are many-to-many relationships. I did the following test as a reference:

    M = 
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER ( ALL ( Table1 ), Table1[Area] = MAX ( Table1[Area] ) )
)

     

    Here is the sample pbix file.


    If the established model is not correct, please provide detailed test data and information so that I can do accurate tests. Looking forward to your reply.


    Best Regards,
    Henry


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

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi Anonymous ,
According to your requirements, the table relationships in the data model are many-to-many relationships. I did the following test as a reference:

M = 
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER ( ALL ( Table1 ), Table1[Area] = MAX ( Table1[Area] ) )
)

 

Here is the sample pbix file.


If the established model is not correct, please provide detailed test data and information so that I can do accurate tests. Looking forward to your reply.


Best Regards,
Henry


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