Count of customer filtered by non related table.

[Varshi288]

Hi  I have  a list of customers grouped by a measure Sales Price(SP) like below table. I need to find the count of customers with the 

Range Slicer.Tthere is no relation between two tables  hence it is difficult to find the count. Any tip? Thanks in advance.

Min SP  Max Sp  SP Range

0	5000	0-5k$
5001	10000	5-10k$
10001	15000	10-15k$

[Jihwan_Kim · Accepted solution]

Hi, @Varshi288 

I tried to create a simple version of your sample.

Please check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file, and all steps are numbered in front of each measure.

https://www.dropbox.com/s/d61t5fua2emuf5t/varshi.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Varshi288]

Thank you @Jihwan_Kim  this solved my issue.

[SushainKoul]

Hi @Varshi288 

Can u once again explain it in a detail as I am not able to get it?

[Varshi288]

Hi  @SushainKoul  by default total count of customers are 139. When I select 10k-15k in slicer the count of customers should be 21. Note There is no relation between two table.

[Anonymous]

hello .. you can use TREATAS  DAX function  in your measure.

https://docs.microsoft.com/en-us/dax/treatas-function