CODEWITHSUNDEEP
powerbidaxpowerquery
usmansharif shaik
usmansharif shaik

Reputation: 75

Dax Calculation on distinct count of column based on 2nd column distinct values

enter image description here

i need to calculate the distinct count of panel names based on distinct vehicle no's

ex: for 6073kxx vehicle -distinct count of panels are 7 . please provide a dax calculation for this. this is sample data I have more vehicle numbers.

Upvotes: 0

Views: 725

Answers (2)

smpa01
smpa01

Reputation: 4282

Try this measure

Measure =
SUMX ( VALUES ( 'Table'[Vehicle No] ), DISTINCTCOUNT ( 'Table'[panel name] ) )

Upvotes: 1

mxix
mxix

Reputation: 3659

Just create a measure to do the distinctcount on the other column.

Create a measure:

Distinct Count of Panels = DISTINCTCOUNT('your Table name here'[Vehicle No])

Upvotes: 1

Related Questions