Show Defaulted Value for All Data When Nothing is Selected in a Slicer

[Justair07]

Hi,

I have a table that contains data for the entire Factory as a whole and broken up into different Areas.

On my combo chart I have a bar that displays the Total Value for either a selected area (I'm using a slicer) or the Total Value for ALL areas (Factory) if nothing is selected in the slicer.

Each area has a Target % that I use to determine the Target Value (see picture of sample data below).

Target Value = (Total Value * Target %)

This works great when the user is selected on a specific area.

The problem is that when I want to see the correct target value for the Factory as a whole, Power BI uses the aggregated percentage of all areas to determine the target % thus the target value. I want the target % for the factory to be defaulted to 5% when nothing is selected.

I hope I explained this well enough to make sense. Not sure if anyone has any tips for me to accomplish this.

Edit: Here is my attempt:

Target Test % = IF( ISFILTERED('Value Stre'[Dept]),MAX('tblWaste'[Target $]),.077)

But now it just reverts to .077 no matter what. Am I focusing on the wrong column for the ISFILTERED function?

Thank you,

- Justin

[v-cherch-msft]

Hi @Justair07

You may have a look at this article about HASONEVALUE vs. ISFILTERED vs. HASONEFILTER functions and ISINSCOPE function.If you need further help,sample data and expected output will be helpful to provide an accurate solution.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Cherie

[Justair07]

@v-cherch-msft Thank you very much, I will look into this and reply back.