Forum Discussion
Ensuring Tooltip Shows Missing Values from Dim Table Regardless of Slicer Selection in Power BI
To achieve the requirement of showing missing values from the dim table in the tooltip regardless of slicer selection, you need to modify the measure to ignore any slicer context. You can achieve this by using the ALL function on the dim table instead of the fact table. Here's the modified measure:
```DAX
# Data Check =
IF (
COUNTROWS (
FILTER (
ALL ( Dim_Table_Region[Dim_Code] ),
NOT ( Dim_Table_Region[Dim_Code] IN VALUES ( Fact_Table_Sales[Fact_Code] ) )
)
) > 0,
"⚠",
""
)
```This modification ensures that the measure evaluates the missing values from the dim table without considering any slicer selection on the fact table. Now, the tooltip will display the missing values from the dim table consistently, regardless of slicer selection.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
To achieve the requirement of showing missing values from the dim table in the tooltip regardless of slicer selection, you need to modify the measure to ignore any slicer context. You can achieve this by using the ALL function on the dim table instead of the fact table. Here's the modified measure:
```DAX
# Data Check =
IF (
COUNTROWS (
FILTER (
ALL ( Dim_Table_Region[Dim_Code] ),
NOT ( Dim_Table_Region[Dim_Code] IN VALUES ( Fact_Table_Sales[Fact_Code] ) )
)
) > 0,
"⚠",
""
)
```
This modification ensures that the measure evaluates the missing values from the dim table without considering any slicer selection on the fact table. Now, the tooltip will display the missing values from the dim table consistently, regardless of slicer selection.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!