Forum Discussion
Generate Series
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.
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.
1 Reply
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.