Skip to Content
0
Oct 18, 2019 at 09:40 PM

how to avoid counting doublication in a measure webi

90 Views

Hello Experts ...

I'm building report with 3 Objects A, B and C. For every A entry, there can be multiple entries of B or multiple entries of C. The report should show the total number of unique As. I have created a measure on universe with count (Distinct A). But when I add this measure with B | C | Count(Distinct A), and use the sum, I get number which is greater than the number of A I actual have because Webi count the total of entries including multiple entries of B and C for one single A. Does anyone know how to have a report which includes the B, C, and count (Distinct A) and get the correct total of unique As

Thanks for your help.