PBI Help

PTI5456 — Mon, 20 May 2024 14:16:13 GMT

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?

Re: PBI Help

sanalytics — Mon, 20 May 2024 14:57:19 GMT

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

topic Re: PBI Help in DAX Commands and Tips

PBI Help

Re: PBI Help