Get Count of Accounts

[sqldev2017]

I have an "Account" dim table ,  "Revenue" fact table.  relationships are formed using the accountId. 

Revenue needs to be put into Buckets like below. 

I need the chart below, which shows COUNT of Accounts falling in each revenue Bucket.

I already have created a measure to have the Bucket value for each Account , But cannot figure out how to get the Count.

The AXIS (for buckets),  I have plotted using a dummy table (which has the bucket values like "<5k" etc ! 

[v-lili6-msft]

hi, @sqldev2017

Do this fit your requiremnet?

please share some simple data sample and expected output for us for us. Do mask sensitive data before uploading

Best Regards,

Lin

[themistoklis]

I dont think you can put 2 measures in one graph.

At least one needs to be dimension (the buckets in your case)