HI Team, could you pls help this requierement

[tkavitha911]

I have a table containing country, sales, and date columns. I need to create a separate calculated table that groups countries under the APAC region, specifically combining Japan and Korea into a single entry. Additionally, I want to display Japan and Korea separately, based on the data from the previous month and the current month.

apac total(all counties)
japan+korea
japan
korea

[v-pnaroju-msft]

Hi @tkavitha911,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Best regards,

Pavan

[v-pnaroju-msft]

Hi @tkavitha911,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Best regards,
Pavan

[v-pnaroju-msft]

Hi @tkavitha911,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Best regards,

Pavan

[v-pnaroju-msft · Accepted solution]

Hi @tkavitha911,

We value your inquiry through the Microsoft Fabric Community Forum.

In response to your query, we have attached the relevant screenshot and the PBIX file to assist you in resolving the issue.

If you find this response helpful, we kindly request you to mark it as the accepted solution and provide kudos, as it may assist other members with similar queries.

Best regards,
Pavan

[Kedar_Pande]

@tkavitha911 

Calculated Table DAX Formula:

APAC Sales Summary =
VAR CurrentMonth = EOMONTH(TODAY(), 0)
VAR PreviousMonth = EOMONTH(TODAY(), -1)

RETURN
UNION(
ROW("Region", "APAC Total (All Countries)", "Sales", 
CALCULATE(SUM('SalesTable'[Sales]), 
'SalesTable'[Country] IN {"Japan", "Korea", "Other_APAC_Countries"})),

ROW("Region", "Japan + Korea", "Sales", 
CALCULATE(SUM('SalesTable'[Sales]), 
'SalesTable'[Country] IN {"Japan", "Korea"})),

ADDCOLUMNS(
FILTER('SalesTable', 
'SalesTable'[Country] = "Japan" && 
'SalesTable'[Date] IN {CurrentMonth, PreviousMonth}
),
"Region", "Japan"
),

ADDCOLUMNS(
FILTER('SalesTable', 
'SalesTable'[Country] = "Korea" && 
'SalesTable'[Date] IN {CurrentMonth, PreviousMonth}
),
"Region", "Korea"
)
)

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Poojara_D12]

Hi @tkavitha911 

• Create a calculated table with:

  1. A combined entry for "Japan & Korea" showing sales for the previous month and current month.
  2. Separate entries for Japan and Korea showing their individual sales for the same periods.

• Steps:

  1. Use the UNION function to merge two parts:
     • A row for "Japan & Korea," combining their sales using CALCULATE with filters.
     • Individual rows for Japan and Korea, filtered by month.
  2. Use CALCULATE to compute sales for the previous and current months.

The result:
A table with three rows—one for "Japan & Korea," one for Japan, and one for Korea—displaying sales for both months.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS