Calculated table with count

[joshua1990]

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?

[v-xiaotang]

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.