Count circular dependency

[Anonymous]

I have a circular dependency for debit amount and credit amount and power bi will not accept a count function for both, only for one. I read the SQLBI page about circular dependecy and tried using ALLNOBLANK as well, but no luck. I would really appreciate the help!

For pcd i used the formula calculate(count(debit_amount)), however I cannot use the same formula for pcd2, when I do i get the error message.

Here is the example.

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, could you please share your solution and accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample and your desired output so that we can help further on it.

Best Regards,

Cherry

[Anonymous]

I posted my actual table. I would like to get the count for the debit and credit column, but i can only get a count of one column because of the ciruclar dependency error.

I found the count of credit in PCD, but got the error when i tried to find the count of debit in PCD2.

[v-piga-msft]

Hi @Anonymous ,

I have a circular dependency for debit amount and credit amount and power bi will not accept a count function for both, only for one.

I'm not clear what is your problem.

If it is convenient, could you share your desired output so that I can understand your requirement and then we can help further on it.

Best Regards,

Cherry