selectedValue months sum

[Udt_KV]

Hi Team,

I want to sum the visible month's in the Overall column.

Thanks,

KV's

[Udt_KV]

It's working, thank you so much 😀

[v-robertq-msft · Accepted solution]

Hi, @Udt_KV 

According to your description, I guess you want to make the Overall column display the total percentage of the selected month, you can follow my steps:

1. Go to power query editor, click on the month columns and select unpivot columns, then change column names, like this:

2. Apply and close the power query editor, then change the format of column [Percentage]:

3. Create a Slicer and place [Month], then create a Matrix and place columns like this, then change the name of total column, like this:

And you can get what you want.

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Udt_KV , Not very clear.

Try like

calculate([measure], all(Table[month]))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.