KPI Card for Gross Margin of Total Revenue

[SandeepKumar123]

Hi Team,

I am preparing a KPI card to find GP against the Total Sales, but unable to get it.

Please help me for this.

[Anonymous · Accepted solution]

Hi @SandeepKumar123 ,

Please try ABS() function, this function will return the absolute value of a number.

For more details, you can read related document: ABS function (DAX) - DAX | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SandeepKumar123]

Ok, I have found it but the problem is (-) icon.

I need to remove the (-) from the percentage.