1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power BI Count between ranges

Discussion in 'Power Pivot, Power Map etc' started by msquared99, Aug 10, 2017.

  1. msquared99

    msquared99 Member

    Messages:
    159
    I have a query setup with all the parameters needed. All I need now is to be able to display my data in groupings like this:

    0 to 25
    26 to 50
    51 to 100
    101 to 150
    151 to 200
    +200

    What is the DAX counter part to COUNTIFS?

    Thanks,

    Mike
  2. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,577
  3. msquared99

    msquared99 Member

    Messages:
    159
    I have a table called Table1. In that table I have a company ID and a total count of employees. The fields are co and EE Count in the table. The count was summed up in the query itself.

    Now I want to break the EE Count into groups mentioned above.
  4. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,577
    I'm not sure I get what end result you are looking for...

    But the set up in PowerQuery mentioned in previous post will get you there.
  5. msquared99

    msquared99 Member

    Messages:
    159
    OK I figured out how to do 0 to 25 in one calculation:
    0 to 25 = countrows(CALCULATETABLE(Company,Company[EE Count] >0 && Company[EE Count] <=25))

    So, how do I create a nested measure for all the groupings listed in my first post?
  6. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,577

Share This Page