cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Country / Region Split - both results in one table

I have data like in picture. I need to calculate measure that shows KPI result in table.
The catch is, I need results per Country and Region but when Region slicer is used, results for this Region and whole related country are showed.

So for example: User not touched Country Slicer but selected "Region A" in Region Slicer - I need to see in table two results:
- Region KPI = 1
- Country KPI = 6 (1+2+3)
Is it possible to be done? I manged to achieve such result with "ALL", but both Country and Region slicers must be used. Thinking if I can achieve with only Region slicer used.

Thank you for help

1 ACCEPTED SOLUTION
Solution Sage

Hi @Pawel_1990 ,

You can  try below measure.

``````Measure =
CALCULATE(
SUM('Table'[KPI Result]),
FILTER(
ALL('Table'[Region]),
OR(
NOT ISINSCOPE('Table'[Region]),
'Table'[Region] IN VALUES('Table'[Region])
)
)
)``````

#Pic1 - Don't select the region slicer.

# Pic2 - Select the region A.

Demo - Country Or Region Split - both results in one table.pbix

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Solution Sage

Hi @Pawel_1990 ,

You can  try below measure.

``````Measure =
CALCULATE(
SUM('Table'[KPI Result]),
FILTER(
ALL('Table'[Region]),
OR(
NOT ISINSCOPE('Table'[Region]),
'Table'[Region] IN VALUES('Table'[Region])
)
)
)``````

#Pic1 - Don't select the region slicer.

# Pic2 - Select the region A.

Demo - Country Or Region Split - both results in one table.pbix

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors