AlanP514Post Patron4 years agoSolvedAggregation logic dax Input Output Market Executive Relevance Category # Model Number(Count) % Share Range DE Above target 18 27.69% DE Middle target 13 20.00% DE Low target 10 15.38% DE Hi...Show Moretamerj14 years agoAlanP514 Ok. Please try% Share Range = VAR Numerator = DISTINCTCOUNT ( TableName[Model Number] ) VAR Denominator = CALCULATE ( DISTINCTCOUNT ( TableName[Model Number] ), ALL ( TableName[Relevance Category] ) ) RETURN DIVIDE ( Numerator, Denominator )
tamerj14 years agoAlanP514 Ok. Please try% Share Range = VAR Numerator = DISTINCTCOUNT ( TableName[Model Number] ) VAR Denominator = CALCULATE ( DISTINCTCOUNT ( TableName[Model Number] ), ALL ( TableName[Relevance Category] ) ) RETURN DIVIDE ( Numerator, Denominator )
tamerj14 years agoAlanP514 Ok. Please try% Share Range = VAR Numerator = DISTINCTCOUNT ( TableName[Model Number] ) VAR Denominator = CALCULATE ( DISTINCTCOUNT ( TableName[Model Number] ), ALL ( TableName[Relevance Category] ) ) RETURN DIVIDE ( Numerator, Denominator )
tamerj1Community Champion4 years agoAlanP514 Ok. Please try% Share Range = VAR Numerator = DISTINCTCOUNT ( TableName[Model Number] ) VAR Denominator = CALCULATE ( DISTINCTCOUNT ( TableName[Model Number] ), ALL ( TableName[Relevance Category] ) ) RETURN DIVIDE ( Numerator, Denominator )
Related contentDax Logic Issue virtual TableLogic problem?Dax LogicAggregation logic daxCommitment value calculating incorrectly - DAX Logic
