Forum Discussion
Solved
DistinctCount Within Table
I have a table that looks like this: Asset IncidentCode Comments Switch1 001 Broken Switch1 001 Fixed Switch1 002 Who knows? Switch2 003 Broken Switch2 00...
Hey ReadTheIron ,
Are you looking for something like this:
Column = CALCULATE(DISTINCTCOUNT(AssetTable[IncidentCode]),ALLEXCEPT(AssetTable,AssetTable[Asset]))
Hey ReadTheIron ,
Are you looking for something like this:
Column = CALCULATE(DISTINCTCOUNT(AssetTable[IncidentCode]),ALLEXCEPT(AssetTable,AssetTable[Asset]))