cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

How to remove AR Table display those amount which is 0.00 ?

Hi All

 
I have below expression working fine :-
AR_AMT_ = if(sum(AR[A/R amount include GST in LC]) =0 , blank(),sum(AR[A/R amount include GST in LC]))
But it display 0.00 amount , in actual fact the amount is zero , it should not appear on the table . 

admin11_0-1611488975065.png

Can some one share with me how to remove them ?

 

Paul

 

1 ACCEPTED SOLUTION

@admin11 

 

Please change the formula to this one and it will bring the results you want.

AR_AMT_ = if(ROUND(sum(AR[A/R amount include GST in LC]),0)=0, blank(),sum(AR[A/R amount include GST in LC]))
 
I have added the ROUND function. It seems that thenumber has multiple decimal places and is slightly above zero. (e.g. 0.000001)

View solution in original post

4 REPLIES 4
Post Prodigy
Post Prodigy

@admin11 

The problem is that the sum calculation looks for rows with values = 0. You have rows for the same company which have -ve and +ve values (whose final sum is 0). These rows are not = 0, therefore they are included.

To remove these:

Create a measure for the sum of values:

 

SumAr = SUM(AR[A/R amount include GST in LC])

 

 

Now use this final measure in the visual:

 

SumAR (no 0 values) = IF(SUMX(Company, [SumAr]) >0, [SumAr])

 

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






@admin11 

 

Please change the formula to this one and it will bring the results you want.

AR_AMT_ = if(ROUND(sum(AR[A/R amount include GST in LC]),0)=0, blank(),sum(AR[A/R amount include GST in LC]))
 
I have added the ROUND function. It seems that thenumber has multiple decimal places and is slightly above zero. (e.g. 0.000001)

View solution in original post

Hi Themis

Thank you so much for sharing the expression work fine,

Paul

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors