% of Column Total

[m83roshdy]

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.

[vicky_]

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

[m83roshdy]

Dear

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