Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Hope someone can help me. I have a slicer of products (for example 10 products)
Now I want in title (fx) of the visualisation see all the selected items from the slicer and when you don't select a product in the slicer than the text "all product".
I tried the measure
Title_Product = "Product : "& if(hasonevalue(‘Product[Productcode]),selectedvalue(' Product[Productcode]), concatenatex('Product,'Product[Productcode],","))
When notihing is selected I got the names of the 10 products... I want then tot see "all products"
Thanks for reaction!
Solved! Go to Solution.
try this:
try this:
Try
Title text =
VAR NumSelectedProducts =
COUNTROWS ( ALLSELECTED ( 'Product' ) )
VAR NumAllProducts =
COUNTROWS ( ALL ( 'Product' ) )
VAR Result =
IF (
NumSelectedProducts = NumAllProducts,
"All products",
CONCATENATEX ( 'Product', 'Product'[Product code], ", " )
)
RETURN
Result
User | Count |
---|---|
57 | |
21 | |
19 | |
17 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |