Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sergio Medina]

Hi

I made a stacked bar chart to show gender data over a period of years, I was able to show the percent with this measure:

Gender % = DIVIDE(DISTINCTCOUNT(‘Table1′[PIDM]),CALCULATE(DISTINCTCOUNT(‘Table1′[PIDM]),ALLEXCEPT(‘Table1’,’Table1′[Year])))

Now the problem I have is that when I add a slicer (lets use state as example) when I click on one of the options the percent show is not within what is filtered.

Example: No slicer shows for 2014 61% Male and 39% Female click on Oregon state slicer and it shows 22% Male and 33% Female which clearly does not add 100%

What I’m doing wrong?

——————————
Sergio Medina
IT
7033827828
——————————

[William Skelley]

Hi Sergio:

I think you want to use “ALLSELECTED” – please see my example. You just swop-in your fields.

Share % of Sales = DIVIDE(

SUMX(Sales, Sales[Sales Amount (Actual)] – Sales[Discount Amount]),

SUMX(ALLSELECTED(Sales), Sales[Sales Amount (Actual)] – Sales[Discount Amount]))

I hope this helps.

Best regards,

Bill S

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————
——————————————-

[Sergio Medina]

You mean this?

Gender % = DIVIDE(DISTINCTCOUNT(‘Table1′[PIDM]),CALCULATE(DISTINCTCOUNT(‘Table1′[PIDM]),ALLSELECTED(‘Table1’,’Table1′[Year])))

Because it doesn’t work

——————————
Sergio Medina
IT
7033827828
——————————
——————————————-

[William Skelley]

Hi Sergio:

I’m happy to look at your file (or abbreviated example) to best answer it.

Thank you,

Bill S.

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————
——————————————-

[Sergio Medina]

Does this help?

——————————
Sergio Medina
IT
7033827828
——————————
——————————————-

[Sergio Medina]

I just noticed that I wasted a day creating a formula when all I needed was to choose 100% stack bar chart, I’m so sorry.

——————————
Sergio Medina
IT
7033827828
——————————
——————————————-