Power BI Count between ranges

[msquared99]

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

 

[Chihiro]

Can you give example of what columns you are using to count and what type of data is in that column?

If possible, upload small sample of your data (just as regular table or data model, doesn't matter).

Typically, I do that type of calculation (bucketing) in PowerQuery stage.
See link for detail.
http://chandoo.org/forum/threads/power-query-without-using-if-function.31541/#post-187511

 

[msquared99]

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.

 

[Chihiro]

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.

 

[msquared99]

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?

 

[Chihiro]

You'd want your group lookup table created. Normally in DAX you can create tables via calculations etc, but can't be done in Excel PowerPivot model.

Hence my suggestion to do it in PowerQuery.

At any rate, see link for detail on creating custom grouping via DAX.
https://www.sqlbi.com/articles/grouping-transactions-by-age-of-customers-in-dax/