Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Pawel_1990
Regular Visitor

Country / Region Split - both results in one table

Pawel_1990_0-1715782562609.png

 

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
xifeng_L
Solution Sage
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.

 

xifeng_L_0-1715784417544.png

 

# Pic2 - Select the region A.

 

xifeng_L_1-1715784445414.png

 

 

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~

 

View solution in original post

1 REPLY 1
xifeng_L
Solution Sage
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.

 

xifeng_L_0-1715784417544.png

 

# Pic2 - Select the region A.

 

xifeng_L_1-1715784445414.png

 

 

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~

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors