Forum Discussion

atziovara's avatar
atziovara
Icon for Helper I rankHelper I
2 years ago

Two filters for the same column

  I want to compute the Weighted Average for one of the following Questions, based on the value of the Answer to another Question. For example, I would like to compute the Weighted Average of t...
Need Help
atziovara's avatar
atziovara
Icon for Helper I rankHelper I
2 years ago

lbendlin Thank you for your response!

 

I don't want the calculation to take place on the row of 'Table'[Weighted Answers] where 'Table'[Questions] =SelectedQuestion2. The row of 'Table'[Weighted Answers] which will be summed nees to be the same as the row where 'Table'[Questions] = SelectedCharacteristic1. Therefore, no multiplication by 0 should take place.

 

Examples:

(1) SelectedQuestion1 = "Liquidity problems intensity"

SelectedQuestion2 = "Expected change in demand in the next 6 months"

SelectedPrice = 1

The expected result should be: [0,006 + (-0,001) + (-0,001)] / (0,006 + 0,001 + 0,001) = 0,5

 

(2) SelectedQuestion1 = "Liquidity problems intensity"

SelectedQuestion2 = "Expected change in demand in the next 6 months"

SelectedPrice = 0

The expected result should be: [0 + 0 + (-0,0057)] / (0,0057 +0,006 + 0,0057) = -0,32759

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

I don't see a "SelectedPrice"  column in your sample data?

  • atziovara's avatar
    atziovara
    Icon for Helper I rankHelper I
    2 years ago

    lbendlin 
    As mentioned on my original post - inside the measure Weighted Average:
    VAR SelectedPrice = SELECTEDVALUE('SelectedCharacteristics'[Answers])

    This means that SelectedPrice is a slicer that takes its values from the column [Answers] of table 'SelectedCharacteristics'.

     

    SelectedCharacteristics is a disconnected table that has been created from summarizing the original table, 'TableBI':

    SelectedCharacteristics =
    SUMMARIZE( 'TableBI',
        'TableBI'[Questions],
       'TableBI'[Answers])