hi

Question

hi
can some one help me for this title measure&nbsp;
&nbsp;
here TOPN is static but i want it dynamic
&nbsp;

Total Sale with VAT (Measure) Dynamic Title Item_name = 
CALCULATE(
&nbsp; &nbsp; CONCATENATEX(
&nbsp; &nbsp; &nbsp; &nbsp; VALUES('bm_retail_t product_file'[ITEM_NAME]),
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'bm_retail_t product_file'[ITEM_NAME],
&nbsp; &nbsp; 
&nbsp; &nbsp; "Total Quantity in KG (Measure", " &amp; "
) &amp; " Highest with- "&amp; FORMAT([Total Sale With VAT (Taka) (Measure)], "0.00"),
&nbsp; &nbsp; &nbsp; &nbsp; TOPN(
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES('bm_retail_t product_file'[ITEM_NAME]),
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Total Sale With VAT (Taka) (Measure)]
&nbsp; &nbsp; &nbsp; &nbsp; 
))

jayee · Answer

Hi&nbsp;abc_777&nbsp;,&nbsp;you can create a "New Perameter" in Modeling tab in report view and give the range you want like 1 to 10 it will create a table with column and measure use the measure insted of 1 give the column in slicer then based on user selection it will change.&nbsp;If this post helps, then please consider&nbsp;Accept it as the solution, Appreciate your Kudos!!

abc_777 · Answer

I have tried so but its not givinig me the right result.&nbsp;

abc_777 · Answer

Hi,
&nbsp;
I have created a parameter name select numbers then in measure i have linked it
&nbsp;

Total in Piece and KG (Measure) Dynamic Title Value_Type = 
CALCULATE(
&nbsp; &nbsp; CONCATENATEX(
&nbsp; &nbsp; &nbsp; &nbsp; VALUES('bm_retail_t product_file'[VALUE_TYPE]),
&nbsp; &nbsp; &nbsp; &nbsp; VALUES('Total in Piece and KG (Measure)'[Total in Piece and KG (Measure) &nbsp;Retail] ) &amp; " "&amp; 'bm_retail_t product_file'[VALUE_TYPE],
&nbsp; &nbsp; 
&nbsp; &nbsp; "Total Quantity in KG (Measure", " &amp; "
) &amp; " Highest with- "&amp; FORMAT([Total in Piece and KG (Measure)], "0.00"),
&nbsp; &nbsp; &nbsp; &nbsp; TOPN(
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('Select Number'[Select Number]),&nbsp; &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES('bm_retail_t product_file'[VALUE_TYPE]),
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Total in Piece and KG (Measure)]
&nbsp; &nbsp; &nbsp; &nbsp; )
)
&nbsp;
when select 1 its ok
&nbsp;

&nbsp;but when select number 2 its shows like this. its adding first&nbsp; and second&nbsp; then 17594068.69

when select number 3 its shows like. its adding first, second and third then 21383488.54&nbsp;

&nbsp;
&nbsp;but i dont want to add or sum.
&nbsp;
i want to see second value 5590993.92&nbsp; and third value 3789419.85 when select number 2 and 3
&nbsp;
thanks
&nbsp;

jayee · Answer

Hi&nbsp;abc_777&nbsp;,&nbsp;Thanks for explaining now i understand your exact requirement.you can create an another measure below oneTop-1 Measure =&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;TOPN(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;SELECTEDVALUE('Select Number'[Select Number])-1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;VALUES('bm_retail_t product_file'[VALUE_TYPE]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;[Total in Piece and KG (Measure)]&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp;use this measure in your measure&nbsp;"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.&nbsp;If this post helps, then please consider&nbsp;Accept it as the solution, Appreciate your Kudos!!

abc_777 · Answer

create&nbsp;
&nbsp;

Top-1 Measure = 
&nbsp; &nbsp; &nbsp; &nbsp; TOPN(
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE('Select Number'[Select Number])-1,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES('bm_retail_t product_file'[VALUE_TYPE]),
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Total in Piece and KG (Measure)]
&nbsp; &nbsp; &nbsp; &nbsp; )
&nbsp;
then put it ti title then when select 1
&nbsp;

when select 2

&nbsp;
when select 3

&nbsp;
when select 4

&nbsp;
&nbsp;

Forum Discussion

hi

9 Replies