Summing Data from One Column Based on Text in Other Column

[MTTsoftwareuser]

Hi All,

I have three columns in a table that I am considering - Hours, Has WO, and Multiple WO.  I'm trying to create a measure that will calculate the Hours for records where Has WO = Yes AND Multiple WO = Multiple and then divide that by the Hours for records where Has WO = Yes.  In the attached pic, the calculations would wind up being 35.5 / 120.

 

I'm using this as my measure:

Chart 4b = DIVIDE(CALCULATE(SUM ('Data'[Hours]),'Data'[Has WO] = "YES"),CALCULATE(SUM ('Data'[Hours]),'Data'[Has WO] = "YES",'Data'[Multiple WO] = "MULTIPLE"))

But my result in PBI is this

I know it's not working because the results aren't percentages and aren't converting to percentages - something tells me it's doing some summing but not division.  

Thanks in advance!

Gregg

[DOLEARY85]

Hi,

based on your description and then measure -  it looks like measure is dividing the total by the amount rather than how it was described above.

i've tried this and it'w working:

Measure = DIVIDE(CALCULATE(SUM('Table (2)'[Hours]),'Table (2)'[Has WO]="Yes",'Table (2)'[Multiple WO]="Multiple"),CALCULATE(SUM('Table (2)'[Hours]),'Table (2)'[Has WO]="Yes"))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[MTTsoftwareuser]

How do I share a download link here @Ashish_Mathur 

[Ashish_Mathur]

Hi,

Upload the file to Google Drive and share the download link here.

[MTTsoftwareuser]

https://drive.google.com/file/d/14x9GGXOIcUrY1q67uvSvknAGpNnylkrj/view?usp=sharing

[Ashish_Mathur]

Access Denied message.