Calculating Percentage of Monthly Total

[nate60db]

Hey everyone,

I'm a newbie so please bare with me. I'm used to Tableau's Compute Using for calculations however I cannot figure out the same query for BI. Please see the screenshot below:

Current look in BI

What I'm hoping to achieve is showing the percentages by month instead of the overall view. I quickly did the same in Tableau which you'll see below.

What I'm hoping for

Link to .pbix file: https://www.dropbox.com/s/7obyar5j3h9ah2i/time%20series_test.pbix?dl=0

Any help would be greatly appreciated!

Many thanks!

[amitchandak · Accepted solution]

@nate60db , try blike

divide(sum(Table[col]),calculate(sum(Table[col]),allexcept(Table[Month-year])))

[nate60db]

many thanks @amitchandak !