hi

Question

hi,
&nbsp;
can some one say how can i pur color when switch between these two measure please
&nbsp;

Total in Piece and KG (Measure) = 
&nbsp;IF (
&nbsp; &nbsp; HASONEVALUE ('Total in Piece and KG (Measure)'[Total in Piece and KG (Measure) ]),
&nbsp; &nbsp; SWITCH (
&nbsp; &nbsp; &nbsp; &nbsp; VALUES ('Total in Piece and KG (Measure)'[Total in Piece and KG (Measure) ]),
&nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; "Total Quantity in Piece (Measure)", ([Total Quantity in Piece (Measure)]),&nbsp; &nbsp; &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; measure 1
&nbsp; &nbsp; &nbsp; &nbsp; "Total Quantity in KG (Measure)", &nbsp;( [Total Quantity in KG (Measure)])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; measure 2
&nbsp; &nbsp; ))
&nbsp;
give me deep Blue and Orange colour code please
&nbsp;
thanks

v-luwang-msft · Answer

Hi&nbsp;abc_777&nbsp;，
Need your sample data and expected output result,pls share it.
&nbsp;
&nbsp;
Best Regards
Lucien

abc_777 · Answer

here is the sample file. please help me with how i can colour for each measure under main measure
&nbsp;
thanks

abc_777 · Answer

Here my new or main measure&nbsp; &nbsp;
&nbsp;
Total in Piece and KG (Measure)&nbsp; is general or decimal
&nbsp;
when i select&nbsp;
&nbsp;
Total Quantity in Piece (Measure) &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; values should come as general or decimal
and
Total Quantity in KG (Measure)&nbsp;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; values should come as 0.00 KG
&nbsp;
&nbsp;
Total in Piece and KG (Measure) =
&nbsp;IF&nbsp;(
&nbsp; &nbsp;&nbsp;HASONEVALUE&nbsp;('Total in Piece and KG (Measure)'[Total in Piece and KG (Measure) ]),
&nbsp; &nbsp;&nbsp;SWITCH&nbsp;(
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;VALUES&nbsp;('Total in Piece and KG (Measure)'[Total in Piece and KG (Measure) ]),
&nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"Total Quantity in Piece (Measure)", ([Total Quantity in Piece (Measure)]),&nbsp; &nbsp; &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; measure 1
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"Total Quantity in KG (Measure)", &nbsp;( [Total Quantity in KG (Measure)])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; measure 2
&nbsp; &nbsp; ))
&nbsp;
thanks

abc_777 · Answer

I tried this but no luck. can some one help me please, thanks
&nbsp;

Total in Piece and KG (Measure) =

&nbsp; &nbsp; SWITCH (TRUE(),
&nbsp; &nbsp; SELECTEDVALUE('Total in Piece and KG (Measure)'[Total in Piece and KG (Measure) &nbsp;Retail]) =
&nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; "Total Quantity in Piece (Measure)", ([Total Quantity in Piece (Measure)]) &amp;&amp; FORMAT([Total Quantity in Piece (Measure)],"#.000"),
&nbsp; &nbsp; SELECTEDVALUE('Total in Piece and KG (Measure)'[Total in Piece and KG (Measure) &nbsp;Retail]) =
&nbsp; &nbsp; &nbsp; &nbsp; "Total Quantity in KG (Measure)", &nbsp;( [Total Quantity in KG (Measure)]) &amp;&amp; FORMAT(([Total Quantity in KG (Measure)]),"#.00")
&nbsp; &nbsp; ))

abc_777 · Answer

cant i pass KG and decimal in anothe rmeasure? can some one help me please

Forum Discussion

hi

5 Replies