Measure works in table but not chart

[Anonymous]

Hi all,

I have a measure called 'cluster' that looks through a table of sales and returns a result of =1 every time an address has more than 1 sale over a 14 day period. Within this table there is a 'count' column that has a value of 1 for each row. When I put address column, cluster measure and count column in a table, I get the below view which is what I would like to see - in this example, a total of 6 addresses had more than 1 sale over a 14 day period, with 15 sales in total. In this case, the count seems to be relating to the cluster. 

I cannot get this to display as a stacked column chart though - what I would like is something to look like the below - but instead of showing 6 clusters for the day (in above example), the chart would instead show the count of 15. Can anyone help please? I think basically it needs to sum the count by day where cluster = 1? 

Thank you.

[Anonymous]

Hi thanks for your response - the 6 lines refer to a single day - they are the result of using a slicer to select just one day, then it displays any 'clusters' which are addresses with >1 sale over a rolling 14 days period, with the last sale ending on the day selected in the slicer.

Thank you. 

[Anonymous]

The measure is (works partly based on another measure that calculates rolling 14 days):

Cluster = countx(filter(summarize(Sales, Sales[Joined Alternate Address], "_1", [Rolling 14] ), [_1]>1),[Joined Alternate Address])

[Anonymous]

HI @Anonymous,

I think these should be related to your chart fields, your measure formula not interact with the current chart axis and legend fields. I'd like to suggest you append them into your summarize functions to match your expression result with current categories.

If you confused about the coding formula, please share some dummy data with raw table structure and expected results to test.

How to Get Your Question Answered Quickly 
Regards,

Xiaoxin Sheng

[jthomson]

This sounds like it's an issue with the context with which the measure is working, but as you've only provided a small fraction of the relevant data and not provided the actual measures you've used, it's hard to say for certain - are those six lines you've copied related to a single day? Multiple days?