Filtering the distinct values of one column and calculate some measures for other columns

[krrish116]

Hi @amitchandak 

Please find the dummy data,

Supp. No.	Cust No.	Cust Name	Value	Compliance	Category
4403843009-00003	33793	G CUSTOM SERVICES INC	$85.00	Compliant	GM
4403843009-00003	33793	G CUSTOM SERVICES INC	$85.00	Compliant	GM
4403843009-00003	33793	G CUSTOM SERVICES INC	$85.00	Compliant	GM
4403843009-00003	33793	M CUSTOM SERVICES INC	$366.50	Compliant	GM
4403843009-00003	33793	M CUSTOM SERVICES INC	$577.60	Compliant	GM
4403843009-00003	33793	WHM CUSTOM SERVICES INC	$486.40	Compliant	GM
4403843009-00003	33793	WHM CUSTOM SERVICES INC	$653.60	Compliant	GM
4403843009-00003	33793	WHM CUSTOM SERVICES INC	$501.60	Compliant	GM
4403843009-00003	33793	WHM CUSTOM SERVICES INC	$760.00	Compliant	GM
4403841515-00001	77159	ONPOINT INDUSTRIAL SERVICES LLC	$278.00	Compliant	GM
4403841515-00001	77159	ONPOINT INDUSTRIAL SERVICES LLC	$278.00	Compliant	GM
4403841515-00001	77159	ONPOINT INDUSTRIAL SERVICES LLC	$278.00	Compliant	GM
4403841515-00001	77159	ONPOINT INDUSTRIAL SERVICES LLC	$227.10	Compliant	GM
4403841515-00001	77159	ONPOINT INDUSTRIAL SERVICES LLC	$542.20	Compliant	GM
4403841515-00001	77159	ONPOINT INDUSTRIAL SERVICES LLC	$732.70	Compliant	GM
4403807762-00004	77857	BROCK SERVICES LLC	$280.90	Compliant	GM
4403807762-00004	77857	BROCK SERVICES LLC	$280.90	Compliant	GM
4403807762-00004	77857	BROCK SERVICES LLC	$280.90	Compliant	GM
4403807762-00004	77857	BROCK SERVICES LLC	$280.90	Compliant	GM

in the above data i have to calculate the sum of value column for distinct of supp.no. column

in excel im getting but im unable to do it in power bi.

DAX Measure i used: 

Total Value = CALCULATE(SUM('alKpis'[Value]),FILTER('alKpis',(DISTINCTCOUNT('alKpis'[supp.no.]))))

Thanks,

Krishh

[krrish116]

Thank you @amitchandak ...

Thank you very much...

let me try thr measure once...

[amitchandak · Accepted solution]

@krrish116 , Try a measure like

Total Value = SUMX(values('alKpis'[supp.no.]),CALCULATE(distinctcount( 'alKpis'[Value])))