Forum Discussion

Helper II

2 years ago

Solved

% not showing correctly

Hi,

I have a stacked bar chart with %. I have created the following formula for the %:

% of Total - Domain = DIVIDE(SUM('Jira Data'[Story Points 1]),

CALCULATE(SUM('Jira Data'[Story Points 1]),

ALLEXCEPT('Jira Data', 'Jira Data'[Domain - Custom])),0

)

When I apply, the slycers quarter, month or year the % shown are incorrect. How can I solve the issue? Thanks!

zenisekd
2 years ago
try to add the date column that is referenced by the filter to the ALLEXCEPT clause.

3 Replies

zenisekd
Super User
2 years ago
try to add the date column that is referenced by the filter to the ALLEXCEPT clause.
Anonymous
Not applicable
2 years ago
Hi EsterBR,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng
EsterBR
Helper II
2 years ago
zenisekd it worked!
I added the columns to the formula:
% of Total - Domain = DIVIDE(SUM('Jira Data'[Story Points 1]),
CALCULATE(SUM('Jira Data'[Story Points 1]),
ALLEXCEPT('Jira Data', 'Jira Data'[Domain - Custom], 'Calendar'[Month],'Calendar'[Quarter],'Calendar'[Month Name])),0
)

Related content