cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

distribution of calculated measure

Hi all,
i dont even know if the subject title fits to what i am actually looking for, but i will try to explain here more in details.
i have model contains 4 different tables/databases: calendar table, products list, customers list and sales table of customers and products bought by them monthly.
i already have measures that:
1. counts num. of products
2. counts num. of customers
I wish to present a clustered column chart which counts how many customers have bought each number of products from 1 to max products i have.
for example, lets say i have 10 products:
dist..PNG  

i wish to get the above result.

thanks in advance,

Amit

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: distribution of calculated measure

File attached.

 

Best

D

View solution in original post

5 REPLIES 5
Highlighted
Anonymous
Not applicable

Re: distribution of calculated measure

File attached.

 

Best

D

View solution in original post

Highlighted
Helper II
Helper II

Re: distribution of calculated measure

Perfect as usual.

Thanks brother.

Highlighted
Frequent Visitor

Re: distribution of calculated measure

I am interested in the solution as well. Unfortunately, the file won't open for me. Is a re-up possible?

Highlighted
Helper II
Helper II

Re: distribution of calculated measure

Hi,

i am not able to upload a pbi file - user restrictions.
anyway, it is not my file.
it is attached above within another reply. 
if still facing an issue then try contact the proposer.

Highlighted
Anonymous
Not applicable

Re: distribution of calculated measure

It will open once you update your PBI Desktop.

Best
D

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.