Stacked bar chart with the part of total

[brohon]

Hi Everyone,

don't you know if it is possilbe that the filter on the dashboard would affect only one of the values in the graph?

I have two tables - customers, transactions.

Customer

Customer ID    |  Full name                  |    Registration date

1                        Ned Stark                        1.3.2014

2                        Jamie Lannister               4.5.2016

3                        Jon Snow                         7.7.2016

Transactions

Transaction ID    |  Customer ID   |   Date          | Salesman   

1                             1                       1.1.2016         Scot

2                             2                       3.5.2016         Joe

3                             1                      7.7.2017         Joe

4                             3                      7.7.2017         Mike

What I'd like to achieve is to have a Slicer that would allow me to filter the dates in which some transactions occured.

Below I'd like to have the stacked column chart, with the Year of Customers' registration date on the X axis and two values:

1. Cout of customers who had a transaction by selected period (no problem with that)

2. All customers who registered in the year (this makes me trouble, because the customers are filtered out by the slicer above)

The Graph should look like something like this:

[v-shex-msft]

Hi @brohon,

I think it is impossible to achieve your requirmetn, if slicer not has any filter effect to current table, it means dax formula can't get the current value form slicer. it will return the wrong result.

Sample:

Count customers who has transaction in selected range works, but count register customers not works.(it only return the static value)

Regards,

Xiaoxin Sheng

[parry2k]

try by adding following measure

Total Customers = Calculate(Count(Customer[Customer Id]), AllSelected(Customer))

[brohon]

Hi,

I've tried your solution but it calculated all customers (not considering the date of registration) and in the graph the same value displayed for each year of registration.

Therefore I modified the Measure to Total Customers = TOTALYTD(COUNT(Customer[Customer Id]);Customers[Registration date];All(Customer)).

This helped to split Counted number between the years of registration. However, it did not solve the problem that the calculated amount is still related to the slicer filter at the dashboard - Transaction[Transaction date].