Slicer: Do not show values for some selections

[tuncay]

Dear community,

I've created a hierachy and put that on a slicer in order to see data.

However, when I select a upper hierarchy (e. g. AB) then it sums all the data and shows a wrong value for AB. I want that no data is shown when I select AB in the upper hierachy. But when I select AB in the bottom the correct data is shown..

I want that only data is shown when the AB in the bottom is selected as the data in the upper hierachy is wrong...

[Anonymous]

Hi @tuncay ，
 Based on your description, it sounds like you're experiencing issues with data aggregation when selecting upper levels of your hierarchy. Here are the steps you can take to troubleshoot this issue:

1.You can write a DAX formula that only returns values when a certain condition is met, such as when a specific hierarchy level is selected.
Here's a sample DAX formula that might help:

Measure = 
IF(
    ISFILTERED('Table'[High Level]),
    BLANK(),
    SUM('Table'[Data])
)

After creating the new measure, test your slicer with various selections to ensure it behaves as expected. If the slicer still does not behave correctly, troubleshoot by checking for any additional filters or interactions that might be affecting the slicer behavior.

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
 

[PijushRoy]

Hi @tuncay 

I have doubts, can you please share more details about the issue? What are the wrong data showing?
Please share some sample data and expected results.