Forum Discussion

prj102's avatar
prj102
Helper I
7 years ago
Solved

Need help with Calculating a % from a table with duplicates

Need help to understand why this calulation is not working as expected.  The measure I'm using is below.  It's close but not perfect.  % of Assets is not calulating the percentage correctly and I've ...
Need Help
  • prj102's avatar
    prj102
    7 years ago

    So I figured it out.  

     

    I created a new measure

    % Unique Assets = DISTINCTCOUNT('Table'[Address])
     
    and changed the value to show value as Percent of grand total.
prj102's avatar
prj102
Helper I
7 years ago

So I figured it out.  

 

I created a new measure

% Unique Assets = DISTINCTCOUNT('Table'[Address])
 
and changed the value to show value as Percent of grand total.