Divide/ % of Total

[chonchar]

Good morning. @parry2k @MFelix 

I had the below measure working until I had to update a connection. But now, this measure is returning 100% for all screens:

% of Total Screens =

Var _totaldomains=

CALCULATE(

    [Total Screens per Domain], // this is a measure that is working correctly. 

    ALL(Appended_Fiscals[Domain]))

return

DIVIDE(

    [Total Screens per Domain],

     _totaldomains,0

    )// now that I look at this, it makes sense that it is returning 100% for all, becasue it is basicaly 1/1=1

In my new model (same measure as above, same data) is returning the below. 

But it worked in my previous model and was returning this. 

.

The above is my expected output. 

Any help would be appreciated. Thank you. 

[MFelix]

Hi @chonchar ,

What type of connection was updated? It seems like you  [Total Screens per Domain] is exactly the same thing has 

CALCULATE(

    [Total Screens per Domain], // this is a measure that is working correctly. 

    ALL(Appended_Fiscals[Domain]))

[chonchar]

@MFelix I connectd a table to a SharePoint site that was previously on my desktop, so I had to redo all the measures to locate the new table (it was named something slightly different).

And you are correct, the measures are the same which is why it's basically giving me 1/1=1.

Maybe you could help me rewrite it? 

[rajulshah]

@chonchar 

You can do one thing. You can create 2 different measures for numerator and denominator and then debug these measures individually.

Please let me know if this doesn't help.

[chonchar]

@rajulshah I just tried that and it is still returning 100%. This is the strangest thing.

[rajulshah]

@chonchar 

Did you validate if the relationships are working or not?

[chonchar]

@rajulshah The relationships are working. The new table is the exact same as the old with a 1:M relationship. 

[rajulshah]

@chonchar Can you try using ALL on the table itself?

[chonchar]

@rajulshah All is already on the table itself:

 It is still returning 1

[MFelix]

Can you share the calculation for the [Total Screens per Domain] please

[chonchar]

@MFelix 

Total Screens per Domain =

COUNTAX(

    Appended_Fiscals,

    Appended_Fiscals[Domain]

)

[MFelix]

The formula should not retrieve the same value, it should return a different value since using the ALL statement removes the row context.

You are using the Domain on your table correct?

[chonchar]

@MFelix Correct. All of the Domains are listed in the (Appended_FiscalsTable). The column name is Domain. 

The Domain is being brought in from the primary key table with 

Domain =

RELATED(User_MasterSP[Domain]

)

But the % of total calculation is only using the (appended_fiscals) table 

[MFelix]

Check if the result for the below part of the code returns the same value for every row if not then is a model issue or a context in your table.

CALCULATE(
    [Total Screens per Domain], // this is a measure that is working correctly. 
    ALL(Appended_Fiscals[Domain]))

[chonchar]

@MFelix 
Model issue?

[MFelix · Accepted solution]

Or visualization because this measure should give you the same value in all the rows.

[MFelix]

@chonchar ,

where you abble to see what was incorrect?

[chonchar]

@MFelix 
I was unable to fix it. But it must be a model issue. I confirmed with someone in my firm and he said the same thing. I have to present at 2pm MST so I am just going to leave the column out for now. 

[MFelix]

If yopu need assistance can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.