Forum Discussion

flunte70's avatar
flunte70
Icon for Helper I rankHelper I
8 years ago
Solved

calculate weighted index

I am trying to make a Measure where I want to calculate weighted index by the following formula:   Weighted CAP index = [CAP Index]*[Actuals]/"the Total of [Actuals]"   but I don't know how to re...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi flunte70,

     

    Create a new measure and use it on your column:

     

    Height Total =
IF (
    HASONEVALUE ( Data[Nummer] ),
    [Height],
    SUMX ( ALL ( Data[Nummer], Data[SC specifikation] ), [Height] )
)

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi flunte70,

 

Try to make two formulas one for Heigth and another for total Height that uses the previous one. If try to make it a full dax measure the context will have to be changed.

 

Regards,

Mfelix

 

 

flunte70's avatar
flunte70
Icon for Helper I rankHelper I
8 years ago

Hi MFelix,

 

I have the flw:

?Height = CALCULATE ( [Actuals]; ALL ( Data[Nummer]; Data[SC specifikation] ) )

?Vægtet KAP OLD = DIVIDE ([KAP Index] * [Actuals]; CALCULATE ( [Actuals]; ALL ( Data[Nummer]; Data[SC specifikation] )))

?Vægtet KAP = IF ( HASONEVALUE ( Data[Nummer] ); [?Vægtet KAP OLD]; SUMX ( ALL ( Data[Nummer]; Data[SC specifikation] ); [?Vægtet KAP OLD] ) )

 

The ? before the name is to keap them in the top of my measures.

"?Height" is returning the Total for all rows which is ok when my "Kategori" filter is off.

I think that the problem with my filter is that it is in a different table as I thought I could enter it in the ALL formula.

"?Vægtet KAP OLD" is returning the weighted CAPS in all the rows but the total is wrong

"?Vægtet KAP" is returning the weighted CAPS in all the rows and the total is right - but not when I filter on "Kategori"?