PBI Help

[PTI5456]

I have a 2 questions:

1. I am trying to remove net zero charges from accounting in my data by same account number. This could potentially inflat my other functions/visuals in Power BI. Is there a way to remove net zero charges?

2. I am trying to sum 1 record with same total charge amount per account number. For example, account number "123" has 3 entries of $5, but total charges of $25. I do not want to sum the $25 3 times, but only once. Is there a way I can account the $25 once in a sum?

[sanalytics]

@PTI5456 

1 -> Dont understand properly.. Need more clarification for that.

2 -> Try below meausre

Measure = 
SUMX(
      VALUES( 'Table'[PAN] ),
      CALCULATE( MAX( 'Table'[Total Charges] ))
)

Hope it helps.

Regards

sanalytics