Distribution of a measure

[josteinross]

Hi all

I have a model in which I have a table that displays customers and each time commercials are displayed to them like so:

Customer	Commercial
1	A
1	B
2	A
3	A
3	B

What I want to do is count the number of distinct commercials each customer is shown, and then aggregate that up to get the amount of customers that get shown 1 commercial, the amount that get 2 etc. 

The final result should in this case look like this:

However, I can't figure out how to display an x-axis like this. Anyone who can help me?

Thanks!

[Jihwan_Kim · Accepted solution]

Hi, 

One of ways to achieve this is to create a result table like below.

[josteinross]

Like clockwork, thank you very much!

[FreemanZ]

hi @josteinross 

try to 
1) create a calculated table like this:

SumTable = 
ADDCOLUMNS(
    VALUES(TableName[Customer]),
    "CommercialCount",
    CALCULATE(DISTINCTCOUNT(TableName[Commercial]))
)

2) plot a column chart like this: