DAX - Count number of Contracts

[PowerBi_NOOB94]

Hi, 

I should conculate the contrats by month and salary costs

The table which are related are many-to-many so i made bridge table. The problem is that this contracts are text values and i don't know who to count rows to see how many contracts they have each month. 

Can somebody help me with this? 

[v-cgao-msft]

Hi @PowerBi_NOOB94 ,

First try changing the direction of the crossfilter for these two relationships to BOTH:

Then check if [Totaal van FDCP] is filtering properly.  If so, you can use the CROSSFILTER() function in your code to specify the direction of the crossfilter for the calculation. (Changing the crossfilter direction to BOTH directly in the model will affect performance.)
CROSSFILTER - DAX Guide
Many-to-many relationship guidance - Power BI | Microsoft Learn

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...