Forum Discussion

Pewima's avatar
Pewima
Regular Visitor
9 years ago
Solved

Ratio using distinctcount

Hello,   I have a table looking as follows:   Country Item France Widget France Widget France Stone Belgium Widget Belgium Widget   What I try to do, is to create a measure that I can filt...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago
    Item Ratio = VAR NumItems = DISTINCTCOUNT([Item])
VAR NumAllItems = CALCULATE(DISTINCTCOUNT([Item]),ALL(WidgetsNStones))
RETURN NumItems/NumAllItems
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago
Item Ratio = VAR NumItems = DISTINCTCOUNT([Item])
VAR NumAllItems = CALCULATE(DISTINCTCOUNT([Item]),ALL(WidgetsNStones))
RETURN NumItems/NumAllItems