Forum Discussion
Target values with ISFILTERED
Hi all Here is a screen recording to my problem statement Sample Data: Plant Cluster Plant Unit Origin Name Target Test.LBV_target Target Test.LBW_Target Loadability Weighted ...
Anonymous Okay, Then try to use HASONEVALUE() instead of ISFILTERED()
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
nandukrishnavs
Community Champion
Community ChampionAnonymous
If the user select multiple values, what is the expected output?
For example, I have used SUM() instead of VALUES().
Try this
Target Value LBW =
IF (
ISFILTERED ( 'Prototype Modeling_Freight'[Origin Name] ),
CALCULATE (
SUM ( 'Prototype Modeling_Freight'[Target Test.LBW_Target] )
),
IF (
ISFILTERED ( 'Prototype Modeling_Freight'[Plant Unit] ),
CALCULATE (
SUM ( 'Prototype Modeling_Freight'[Target Test.LBW_Target] )
),
BLANK ()
)
)Change the logic based on your actual requirement.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
When multiple filters are selected, I want the gauge to show no target values.
according to your suggestion of using when using (SUM) target values have stopped showing
- nandukrishnavs
Anonymous Okay, Then try to use HASONEVALUE() instead of ISFILTERED()
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂