cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Measure in Percentage disappear my visual

Hi again experts,
i have a issue with a measure

this measure  (fig 1) show me a result that i need but i need now the percentage by month (that is not a date)
so i created the new measure that is show in (fig 2) but that makes my visual disappear and even using the option

(percentage of grand total) makes the same effect but when i do something like the measure in (fig 3) the visual go back and show percentage as a normal way.

i need to be show the percentage by MES(month) so ENERO(january) will have all his values to 100% and so for the other months FEBRERO(February), MARZO(march)

thanks you all.

1 ACCEPTED SOLUTION

Accepted Solutions
Senior Member

## Re: Measure in Percentage disappear my visual

@Kevin_Quispe23 wrote:

i upload my db with fake data i need calculate the percentage by MES so the first column enero
would be yellow 71% black 8% and  21% gray.

How are you calculating those percentages? When I look at the raw figures for [Analisis_Masivol] I see

Yellow 502  (70.4%)

Black    61   (8.6%)

Gray   150   (21.0%)

Which rounds to 70%, 8% and 21%. Not 70% 9% and 20% - I don't know why the percentages are slightly different.

However the following formula produces the above percentages

```Particip_Analisis = DIVIDE([Analisis_Masivo1],
SUMX(ALLSELECTED(BBDDALTA[MATRIZ RC (grupos)]), [Analisis_Masivo1]))```
6 REPLIES 6
Senior Member

## Re: Measure in Percentage disappear my visual

Have you tried changing your call to ALLEXCEPT to include both the "MES" and "MATRIZ RC (grupos)" columns?

eg  ALLEXCEPT(BBDDALTA ; BBDDALTA[MES] ; BBDDALTA[MATRIZ RC (grupos)] )

If you just do the ALLEXCEPT with the MES column it strips the filter off the MATRIZ RC (grupos) column which means that the SELECTEDVALUE you use in your [Analisis_Masivol] measure will fail. I'm not complete sure I understand your issue, but if my guess here is correct this might fix it.

However sometime ALLEXCEPT strips off too much of the filter context (as it affects related tables) so sometimes the following pattern using ALL and VALUES needs to be used.

ALL(BBDDALTA)  ; VALUES( BBDDALTA[MES] ) ; VALUES( BBDDALTA[MATRIZ RC (grupos)] )

Frequent Visitor

## Re: Measure in Percentage disappear my visual

Hi @d_gosbell i actually test with allexcept(with MES) and won't work all the columns show 100% in all the divisions and with values happend the same what i need to be show is the percentage by column Mes so for example Enero would be 21% gray 9% Black 70% yellow. Thx 4 the attetion.
Senior Member

## Re: Measure in Percentage disappear my visual

Ok, it's pretty hard to understand what is going on without access to some data. Are you able to post a few rows of sample data and the expected output from that sample data. This does not have to be real data, a small set of data with 10-20 rows and a handful of columns (enought to illustrate your issue) would be ideal.

Frequent Visitor

## Re: Measure in Percentage disappear my visual

i upload my db with fake data i need calculate the percentage by MES so the first column enero
would be yellow 71% black 8% and  21% gray.

please i need help on this.

Senior Member

## Re: Measure in Percentage disappear my visual

@Kevin_Quispe23 wrote:

i upload my db with fake data i need calculate the percentage by MES so the first column enero
would be yellow 71% black 8% and  21% gray.

How are you calculating those percentages? When I look at the raw figures for [Analisis_Masivol] I see

Yellow 502  (70.4%)

Black    61   (8.6%)

Gray   150   (21.0%)

Which rounds to 70%, 8% and 21%. Not 70% 9% and 20% - I don't know why the percentages are slightly different.

However the following formula produces the above percentages

```Particip_Analisis = DIVIDE([Analisis_Masivo1],
SUMX(ALLSELECTED(BBDDALTA[MATRIZ RC (grupos)]), [Analisis_Masivo1]))```
Frequent Visitor

## Re: Measure in Percentage disappear my visual

@d_gosbell  thanks that´s exactly what i needed i calculate the percentage with a calculator xD but i forgot to round the decimals.
Greetings from Perú.