Let suppose table contains the product category and product sub category. Then header only to show the product category which is filtered.
This can be achieved by card visual and DAX expression.
Step1: Create new measure.
Step2: Write DAX expression like below.
header =
CALCULATE (
IF (
ISFILTERED ( DimProductCategory[EnglishProductCategoryName] ),
"Results for Product Category name "
& CONCATENATEX (
VALUES ( DimProductCategory[EnglishProductCategoryName] ),
( DimProductCategory[EnglishProductCategoryName] ),
"|"
),
"Showing results for all Categories"
)
)
CALCULATE (
IF (
ISFILTERED ( DimProductCategory[EnglishProductCategoryName] ),
"Results for Product Category name "
& CONCATENATEX (
VALUES ( DimProductCategory[EnglishProductCategoryName] ),
( DimProductCategory[EnglishProductCategoryName] ),
"|"
),
"Showing results for all Categories"
)
)

No comments:
Post a Comment