dax expression to calculate % coming from 2 different tables

[JLMJ]

Hello!

I have a table of names on a product level

I need to populate this table. How do I put in dax the % TO TOTAL DISTINCT PER GRP 1?

Note: Names per GRP1 aren't unique. ex: Ruth and Jolo ordered both appetizer and mains but should only be counted as 2 for the denominator.

Thanks!

[FreemanZ · Accepted solution]

hi @JLMJ 

not sure if i fully get you.

you may try to plot a table visual with necessary columns and two measures like:

#Names = DISTINCTCOUNT(data[name])

%PerGRP1 = 
VAR GrpCount =
CALCULATE(
    [#Names],
    data[GRP1] = MAX(data[GRP1]),
    ALL(data)
)
VAR Result = DIVIDE([#Names], GrpCount)
RETURN Result

it worked like:

[JLMJ]

Hey it worked! Thanks a lot!