We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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
Solved! Go to Solution.
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~
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~
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
19 | |
13 | |
11 | |
7 |