Generate Series

[Anon42]

Hello,

I have used GENERATESERIES to allow me to toggle 1 to 5 on two slicers, which make up my 'total' measure.

I'm trying to filter so the slicer will only apply to #3 in the table, i.e. if I change it to Impact 5 x Likelihood 5 the total column will be 25, but it changes for all items in the table and not just #3.

Grateful for any help.

[Anonymous · Accepted solution]

Hi @Anon42 ,
I create a table as you mentioned.

Then I create a new measure named total.

total =
SUM ( 'Table'[Impact] ) * SUM ( 'Table'[Likelihood] )

I think you can try this measure.

Measure =
VAR _A =
    SELECTEDVALUE ( 'Table'[Impact] )
VAR _B =
    SELECTEDVALUE ( 'Table'[Likelihood] )
RETURN
    IF ( SELECTEDVALUE ( 'Table'[#], 3 ), _A * _B, 'Table'[total] )

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.