Line Chart

[Anonymous]

Hi,

I have the following as a measure:

Q1_T2B =

CALCULATE(

(CALCULATE(SUM(TABLE[wgt]),TABLE[Q1_Index]<3))

/

(CALCULATE(SUM(TABLE[wgt]),TABLE[Q1_Index]<5))

)

I've read and watched a lot of examples but most of them use date.  I've tried using some non-date solutions but when I put my wave in my x axis then nothing appears in the line chart.  I've tried many different things but can't seem to get anything to work.  Does anyone have any solutions I can try out?

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please update the formula of your measure as below:

Q1_T2B =
VAR _selwave =
    SELECTEDVALUE ( 'TABLE'[WAVE] )
RETURN
    DIVIDE (
        CALCULATE ( SUM ( 'TABLE'[WEIGHTS] ), 'TABLE'[Q1_Index] < 3 ),
        CALCULATE (
            SUM ( 'TABLE'[WEIGHTS] ),
            FILTER (
                ALL ( 'TABLE' ),
                'TABLE'[Q1_Index] < 5
                    && 'TABLE'[WAVE] >= _selwave - 1
                    && 'TABLE'[WAVE] <= _selwave
            )
        ),
        0
    )

If the above one is not your expected result, please provide your expected result with samples and calculation logic base on current sample data. Thank you.

Best Regards

[Anonymous]

Hi @Anonymous 

How do I add ALLEXCEPT to the measure so that I can use filters with it?  I want to filter by GENDER for example