Forum Discussion

DeeA's avatar
DeeA
Frequent Visitor
2 years ago

DIstinct count based on multiple conditons

Hi parry2k,   Can you please assist; I have a table that looks like below; I want to be able to 1. countdistinct the number of cities per customer for each month for an output similar to b...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

 

Please note that Oklahoma is a state, not a city.
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523