Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Use non-blank values only

I want to calculate the percentage of a column. Normally the formula I would use is this:     Percentage = DIVIDE('QC Total Table'[Linear KM], SUM('QC Total Table'[Linear KM]))   However, I wa...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    Try this

    QC %GT Complete = 
IF('QC Total Table'[QC Artist] <> BLANK(), 
	DIVIDE('QC Total Table'[Linear KM], 
		Calculate(SUM('QC Total Table'[Linear KM]),Filter('QC Total Table', 
'QC Total Table'[QC Artist] <> BLANK()))))

     

parry2k's avatar
parry2k
Super User
8 years ago

Try this

QC %GT Complete = 
IF('QC Total Table'[QC Artist] <> BLANK(), 
	DIVIDE('QC Total Table'[Linear KM], 
		Calculate(SUM('QC Total Table'[Linear KM]),Filter('QC Total Table', 
'QC Total Table'[QC Artist] <> BLANK()))))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Gah, I knew I was close. Thank you!