Count of Customers by type updating with slicer

[Anonymous]

Hey All,

I believe I have searched everywhere and tried everything that I have found, I have gotten close, but cant quite make this work. I have customer broken out by Business Unit (BU) and each Business Unit has a type.  What I need is to then have a distinct count of customers under each type unique per BU.   

Here is a sample of my data,                      CustomerID BU Type 1 a Cloud 1 b Prem 1 c Prem 2 a Cloud 2 c Cloud 3 b Prem 3 c Prem

output:                            CustomerID CountBU Cloud 1 Prem 1  Hybrid 1

At this point it would be easy to create, the tough part arrises when I have a slicer on BU so that if the BU slicer is populated (can be multi select) the values should update appropriately. 

Here is a sample of my data,                                            CustomerID BU type 1 a Cloud 1 b Prem 1 c Prem 2 a Cloud 2 c Cloud 3 b Prem 3 c Prem

Example   BU Slicer is set to "A"  Type CustomerCount  Cloud 2 Prem 0  Hybrid 0  I dont need to see the 0s just showing

I do know it needs to be a measure so that it will update with the slicer. 

[v-yulgu-msft]

Hi @Anonymous,

To calculate the distinct count of customers under each type which is dynamically changed based on slicer selection, you can use this measure:

Measure = DISTINCTCOUNT(data[CustomerID])

But I have some concerns:

Why are the result values 1 in below screenshot?

What does the highlighted message mean?

Best regards,

Yuliana Gu

[Anonymous]

@v-yulgu-msft  Thank you for the response, and apologies as I dont completely know what I need to do, it is tough to explain the question.  But the Calculation is a bit more then just the distinctcount.  Those columns show 1 because that is the desired result, that should say count of BUs.  For the message about 0s, I was just stating that I do not need the output to show the rows that have 0 count.

What I was trying to show with the second table is that once you use the slicer, the customer that was previously shown as Hybrid would now be shown as cloud because that is now the only type in the list and the other customer is filtered out 

[Anonymous]

Any other ideas with this?

Thanks in advance