Need to avoid double-counting of Intercompany count using measure.

[ashwingupta]

Hi,

I want to display Journal IDs and their Intercompany status on a bar graph. So what happens right now is that as a few of the IDs have both Intercompany and other transactions, these are double counted for both Yes and No.

I have a set of 10,000 IDs but the bar graph shows a total of 13,000 when Intercompany is added as legend due to double counting.

Requirement - IDs with both types of transactions should be counted only as Yes, and not for both Yes and No. I need to display the data on a bar graph. Any quick fix for this? Thanks!

[amitchandak · Accepted solution]

@ashwingupta , Try new column

New column =
var _1 = countx(filter(Table,[Journal ID] = earlier([Journal ID]) && [Intercompany] = "No"),[Intercompany])
return
if(not(isblank(_1)), "No", "Yes")