Forum Discussion

m83roshdy's avatar
m83roshdy
Regular Visitor
2 years ago

% of Column Total

Hi All,

 

I have a table 'Product' that includes columns [Date], [Product] and related table 'Calendar' that includes columns [Date], [Year], relation is one-to-many

 

I want to calculate the percentage of the total column by DAX in this way:

 

 

 

 

 

Despit of diminsions If I select vertically or horizontally, it should calculate the percentage of Column total, like shown in the pictures above

I'm using PowerPivot for Excel 365 (not Power BI)

 

Thanks in advance.

Need Help

2 Replies

  • vicky_'s avatar
    vicky_
    Icon for Super User rankSuper User
    2 years ago

    drag the units (again) into the values section, right-click and go to Value Field Settings > Show Values As > % of Column Total.

    • m83roshdy's avatar
      m83roshdy
      Regular Visitor
      2 years ago

      Dear

      As per the current situation, I need a measure to calculate it.