Sum of the Dimensions rows gives a different total

[Anonymous]

Hi guys. I have a problem with my power bi. I did the  distinct count of the id´s. Gave me the value wich is presented in the image above, the big problem started when i put the valuues in tables and decided to see these values distributed by the three dimensions. (Image). The total show in each of the tables is the same and is the count of the id´s of my factual. But if we do the sum of each rows we will see that this value does not cprrespond to the count.

I want the grand total and i want the count of rows in segments to give me the same value as the grand total.

[Anonymous]

[Icey]

Hi @Anonymous ,

This is because the total value has nothing to do with the above rows. In other words, the total value is not calculated by sum the above rows' value. It is calculated based on the whole table (in the example below). 

Let's take an example:

Hope I explain it clearly.

Best Regards,

Icey

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

[Anonymous]

[Anonymous]

Hello. I understand that there are columns in which the ID is repeated but the DIR linked to this ID does not. So I'm trying to make a dax query that counts the different ID's and if it has two directions consider just one

[Icey]

Hi @Anonymous ,

---

@Anonymous wrote:

Scheme

Table_F_: id, Id_seg, id_status, id_dir, Count_Id (Fact)

Table_ D_Mon: id_seg, mon_name (Dim)

Table_D_Status: id_status, status_name (Dim)

Table_D_Dir: id_dir, dir_name (Dim)

---

---

@Anonymous wrote:

Hello. I understand that there are columns in which the ID is repeated but the DIR linked to this ID does not. So I'm trying to make a dax query that counts the different ID's and if it has two directions consider just one

---

How do you create the column/measure of "Count_Id" in your Fact table?

Best Regards,

Icey

[Icey]

Hi @Anonymous ,

Scheme

Table_F_: id, Id_seg, id_status, id_dir, Count_Id (Fact)

Table_ D_Mon: id_seg, mon_name (Dim)

Table_D_Status: id_status, status_name (Dim)

Table_D_Dir: id_dir, dir_name (Dim)

---

Could you create a sample .pbix file for me to test? Please don't contain any sensitive information.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

[Anonymous]

Scheme

Table_F_: id, Id_seg, id_status, id_dir, Count_Id (Fact)

Table_ D_Mon: id_seg, mon_name (Dim)

Table_D_Status: id_status, status_name (Dim)

Table_D_Dir: id_dir, dir_name (Dim)