Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate duplicate data

Here are my data:   Company Site Managed by Company A? Total kWh A 1   100 A 2   200 A 3   150 A 4   300 A 5   70 B 2 Yes 200 B 3 Yes 150 B 5 Ye...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ，

     

    Create 3 measures as below:

     

    Sum of kWh for Company A = SUMX(FILTER(ALL('Table'),'Table'[Company]="A"),'Table'[Total kWh])
    Sum of kWh for Company B = SUMX(FILTER(ALL('Table'),'Table'[Company]="B"),'Table'[Total kWh]) 
    Sum of kWh for Group X = SUMX(ALL('Table'),'Table'[Total kWh])-SUMX(FILTER(ALL('Table'),'Table'[Company]="B"&&'Table'[Managed by Company A?]="Yes"),'Table'[Total kWh])

     

    And you will see:

    For the related .pbix file,pls click here.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous,

Thank you for your help!

 

I'm just curious, is it possible to get the result that I want without using [Managed by Company A?] column?

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ，

 

If dont use [Managed by Company A?] column ,how to know that which value needs to be removed?

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!