Measure Calculations decimal point

[achanikya]

Hi team,

Here I am trying to calculate the measure value TCS_AMT. The following is the query that we have used in DB.

 Sum((
(Nvl(Nvl(T502.C502_Ext_Item_Price,T502.C502_Item_Price),0) * Nvl(T502.C502_Item_Qty,0))+
((Nvl(Nvl(T502.C502_Ext_Item_Price,T502.C502_Item_Price),0) * Nvl(T502.C502_Item_Qty,0))* Nvl(T502.C502_Igst_Rate,0)/100) +
((Nvl(Nvl(T502.C502_Ext_Item_Price,T502.C502_Item_Price),0) * Nvl(T502.C502_Item_Qty,0))* Nvl(T502.C502_Cgst_Rate,0)/100) +
((NVL(NVL(t502.c502_ext_item_price,t502.c502_item_price),0) * NVL(t502.c502_item_qty,0))* NVL(t502.c502_sgst_rate,0)/100)) * Nvl(T502.C502_Tcs_Rate,0)/100) As TCS_AMT

The calculation that I used in power BI Desktop was

Created all the measures for IGST,GST,CGST .We are expecting the value for the TCS_AMT ="5015.775" and we are not supposed to use 1000 divider for the above formula.Could anyone of you please let me know the solution for this.

[v-xiaotang]

Hi @achanikya 

Thanks for reaching out to us.

you can try something like this  powerbi - How to conditionally display decimals in a measure in Power BI - Stack Overflow

FORMAT([SimpleMeasure], "#,##0")

or select that measure and 

Best Regards,

Community Support Team _Tang

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