need to sume genres from different enterprises

[Anonymous]

I have 70 enterprises, and need to sume the percentage difference of a genre separately.

I mean:

Enp1-> 22women/50employees

Ent 2 -> 55/22

Ent 3-> 21./33

So, I want to sume (22/50 + 55/22 * 21/33)/3

[v-frfei-msft]

Hi @Anonymous,

We can create two measures as below. If it doesnt't meet your requirement, kindly share your sample data to me.Please upload your files to One Drive and share the link here.

Measure = 
DIVIDE (
CALCULATE ( COUNTROWS ( Table1 ), FILTER ( Table1, Table1[gender] = "male" ) ),
CALCULATE ( COUNTROWS ( Table1 ), FILTER ( Table1, Table1[gender] = "female" ) )
)

Measure 2 = 
SUMX ( VALUES ( Table1[Ent] ), [Measure] )

Also please find the pbix as attached.

Regards,
Frank

[Anonymous]

What I need is "cantidad de mujeres" (quantity of woman) to be "Mujer/Quantity of people in that enterprise". But not as a table, because I need that "total" be equal to (0% + 0% + 50% + 46,15% + 37,74%)/5. This equation is equal to 26,78%, not 23,46%. This 23,46% is the result of "83/Total of the people)

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To update the formula as below.

Measure 2 = 
VAR _result =
    SUMX ( VALUES ( Table1[Ent] ), [Measure] )
VAR _count =
    CALCULATE ( DISTINCTCOUNT ( Table1[Ent] ), ALL ( Table1 ) )
RETURN
    IF ( ISINSCOPE ( Table1[Ent] ), _result, _result / _count )

Please find the pbix as attached.

Regards,

Frank

[Anonymous]

Really REALLY thanks man..!!