Count the number of values that are less than and above a certain value

[Anonymous]

I have a dropdown list of shares, when I click on a share I would like a pie chart to display that shows how many clients have shares that are greater than 1000000 and less than 1000000. So if I click on XYZ for example, a pie chart should show that 2 clients have shares greater than 1 million and 2 clients have shares less than 1 million.

Sample data:

[Washivale · Accepted solution]

Hi @Anonymous ,

create two measures as below and use it in the value section of your pie chart.

Holding_le = CALCULATE(COUNTROWS(Holdings), Holdings[Holding Quantity] <=1000000)

Holdings_gt = CALCULATE(COUNTROWS(Holdings), Holdings[Holding Quantity] >1000000)

if you want to count distinct customers, you can change countrows to distinctcount with code.

let me know if it works with your requirements.

Regards,

Washivale