Percent of Row Total

DAX DAX Calculations
1

Hello Team,

Hope you all are doing well.

I have a scenario where when am selecting
Percent_Sample_file.pbix (48.6 KB)
the “Percent of Row Total” from the format tab the percent is calculating from overall total of years(2020 and 2021), but I want the percent to be calculated based on Individual Years Total.

Any help on this is appreciated.

Before Calculation
image

After Percent Calculation
image

Sample PBIX File attached…

2

Hi @Dharma

Create a measure

image
image1293×358 27.2 KB

image
image895×564 21.4 KB

Percent_Sample_file.pbix (49.5 KB)