Calculated Table

[ricardocamargos]

Hi there!

I need to create a visual which shows products bought by customers (It's like a histogram). For example:

100 customers buy only 10 products

  50 customers buy only 15 products...

I tried to create a calculated table, it works. However when I filter any date the values are wrong. I think calculated table is evaluated when the data is loaded, so it's not affected by filters on the visual. After that, I tried to use a measure (DISTINCTCOUNT(PRODUCTS)) in a column. but it doesn't work.

Does anyone know how to create a visual like that ?

Thank you,

Ricardo

[Anonymous]

HI @ricardocamargos,

Please provide some sample for test, it will be help for analysis.

Regards,

Xiaoxin Sheng

[ricardocamargos · Accepted solution]

Hi @Anonymous,

Do you mean sample about data or structure ??

I solve this situation with dynamic segmentation, I saw it on this website:

http://www.daxpatterns.com/dynamic-segmentation/

Thank you,

Ricardo