Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need to select 2 values from slicer to populate the correct value.
How to modify the measure to the below selectedvalue?
[Product] | Slicer [Country] | Slicer [ Name] |
Product A | US | Product A |
Product B | US | Product B |
Product C | Canada |
|
Measure =
IF(
ISFILTERED(Slicer[Name]),
SWITCH(
SELECTEDVALUE(Slicer[Name]),
"Product A",CALCULATE(MAX([Value]),FILTER('Table',[Product]="Product A")),
"Product B",CALCULATE(MAX([Value]),FILTER('Table',[Product]="Product B")),
"Product C",CALCULATE(MAX([Value]),FILTER('Table',[Product]="Product C"))),
CALCULATE(MAX([Value]),FILTER('Table',[Product]="All")))
Solved! Go to Solution.
Hi @PBI_newuser,
Perhaps you can try the following measure formula if it meets your requirement:
Measure =
CALCULATE (
MAX ( [Value] ),
FILTER (
ALLSELECTED ( 'Table' ),
IF (
ISINSCOPE ( Slicer[Country] ),
[Country] IN VALUES ( Slicer[Country] ),
[Country] = "All"
)
&& IF (
ISINSCOPE ( Slicer[Name] ),
[Name] IN VALUES ( Slicer[Name] ),
[Name] = "All"
)
)
)
Regards,
Xiaoxin Sheng
Hi @PBI_newuser,
Perhaps you can try the following measure formula if it meets your requirement:
Measure =
CALCULATE (
MAX ( [Value] ),
FILTER (
ALLSELECTED ( 'Table' ),
IF (
ISINSCOPE ( Slicer[Country] ),
[Country] IN VALUES ( Slicer[Country] ),
[Country] = "All"
)
&& IF (
ISINSCOPE ( Slicer[Name] ),
[Name] IN VALUES ( Slicer[Name] ),
[Name] = "All"
)
)
)
Regards,
Xiaoxin Sheng
@PBI_newuser , Try a measure like
Measure =
IF(
ISFILTERED(Slicer[Name]) || ISFILTERED(Slicer2[Name]) ,
CALCULATE(MAX([Value]),FILTER('Table','Table'[Product] in allselected(Slicer[Name]) && 'Table'[COUNTRY] in allselected(Slicer2[Name]) )))
@PBI_newuser , Not able to relate what is raw data, What are the slicers? Are slicer independent so we need handle. What is final outcome needed
@amitchandak this is an issue arised from the below topic.
https://community.powerbi.com/t5/Desktop/Slicer-for-all-products/m-p/1488926#M618213
I have 2 slicers for user to select which are "Country" and "Name".
How can I include these 2 fields in the "SELECTEDVALUE" function?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |