Calculated table with count

joshua1990 — Mon, 06 Jun 2022 08:52:32 GMT

Hi experts!

I would like to create a calculated table with dax that shows me some dimensional data including the number of weeks where a specific goal has been reached.

The data model has a

simple calendar table (Date, Week,Month)
team table (County, Team, Product)
and a sales table (Product, SalesVolume, SalesRevenue, Date)

Those tables are linked by Date and Product.

Now I would like to create a table that shows for each country and team those kind of goals:

Sales
- Good: > 100
- Neutral > 50
- Bad < 50
Revenue
- Good > 500
- Neutral > 250
- bad >250

I would like to see the number of weeks where this kind of goal has been reached.

The tables should look like this:

Country	Team	KPI	Goal	Frequence
France	A	Sales	Good	10
France	A	Sales	Bad	5
France	A	Sales	Neutral	3
France	B	Revenue	Good	12
France	B	Revenue	Bad	6

How would you do that with DAX?

Re: Calculated table with count

v-xiaotang — Thu, 09 Jun 2022 02:45:06 GMT

Hi joshua1990

Thanks for reaching out to us.

Could you please provide some sample data of table sales according to the expected outcome you provide? Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

topic Calculated table with count in DAX Commands and Tips

Calculated table with count

Re: Calculated table with count