The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
25 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |