Forum Discussion
Account total error
Good day everyone,
I have a dashboard with a problem in the total count of the academic programs that each of the universities have. The total of the programs gives me 10,993, however, when I add each of the counts of the academic programs that universities have the true total is 11,011, there is a difference of 18 programs.
I would like them to help me find a solution to that difference, taking into account that to assemble that matrix I am relating two tables one that has the name of the universities and the other where I am doing the count.
The formula I am using to count the programs is as follows:
7 Replies
Syndicate_Admin , Hope you are not looking for distinctcount
distinctcount(Table[Program])
or there is join issue between table, having a many to many join
Good afternoon amitchandak,
The relationship I have between tables is one to many:
On the other hand, I tried using the distinctcount function and the result I got was the same:
Appreciate
Good afternoon ADPowerBI1,
The relationship I have between tables is one to many:
On the other hand, I tried using the distinctcount function and the result I got was the same:
Hi
try this measure,Calculate(SUMX( VALUES (Accuracy[Product Name]), calculate (SUMX( VALUES (Accuracy[Product Name]), [count measure] ))))
Thanks ,
ThennarasuHello Thennarasu,
I tried to use the measure you suggested, but it throws me the following error:
Is there something in the syntax of the measure that could have gone wrong?
I thank you for the help you can give me.
Good morning
I have not yet received a response to my request. I will be very grateful, if you help me solve my case.
