Forum Discussion
hi
I have tried so but its not givinig me the right result.
Hi,
I have created a parameter name select numbers then in measure i have linked it
but when select number 2 its shows like this. its adding first and second then 17594068.69
when select number 3 its shows like. its adding first, second and third then 21383488.54
but i dont want to add or sum.
i want to see second value 5590993.92 and third value 3789419.85 when select number 2 and 3
thanks
Hi abc_777 ,
Thanks for explaining now i understand your exact requirement.
you can create an another measure below one
Top-1 Measure =
TOPN(
SELECTEDVALUE('Select Number'[Select Number])-1,
VALUES('bm_retail_t product_file'[VALUE_TYPE]),
[Total in Piece and KG (Measure)]
)use this measure in your measure "Total in Piece and KG (Measure) Dynamic Title Value_Type" after TOP N with negative(-) sign so it will remove other values coming from the measure and also Test for selecting 1 in slicer.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
create
Top-1 Measure =TOPN(SELECTEDVALUE('Select Number'[Select Number])-1,VALUES('bm_retail_t product_file'[VALUE_TYPE]),[Total in Piece and KG (Measure)])then put it ti title then when select 1when select 2
when select 3
when select 4
Can you try below measure if still not work please send a sample file with out any sensitive information so that i can check and provide you further support?
Top-1 Measure =
CALCULATE (
[Total in Piece and KG (Measure)],
TOPN (
SELECTEDVALUE ( 'Select Number'[Select Number] ) - 1,
VALUES ( 'bm_retail_t product_file'[VALUE_TYPE] ),
[Total in Piece and KG (Measure)]
)
)If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
