Matrix Calculations

[rushangbhardwaj]

I have a matrix table of my customer based on total revenue. This matrix table is summarized over the total data. I want to be able to find a breakdown of customers based on "how many customers are in a certain threshold of revenue".

For example: I want to find customers who are above 1 million dollar of overall revenue but less than 10 million dollar of overall revenue. 

Any suggestions?

Thank you in advance.

[Ashish_Mathur · Accepted solution]

Hi,

Drag the measure to the visual filter section and apply a criteria of >=1 and <=10.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490