Target values with ISFILTERED

[Anonymous]

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
NORTH	BIHAR	Purnia Depot	718320	964.32	97.91%
NORTH	NORTH EAST	Fatuha Depot	773091	1220.67	97.03%
NORTH	ODISHA	Rourkela Depot	225762	374.36	97.00%
NORTH	ODISHA	Khurda Depot	285980	383.15	96.02%
NORTH	BIHAR	Patna Depot	470353	1235.78	95.74%
NORTH	NORTH EAST	Gourpuri Depot	586602	1182.86	95.09%
NORTH	JHARKHAND	Ranchi New Depot	679728	1140.72	95.02%
WEST	PUNE	Kolhapur Depot	84564	155.52	94.69%
SOUTH	VIZAG	Vizag Depot	477480	671.24	94.15%
NORTH	SILIGURI	Asansol Depot	96855	156.75	93.94%
WEST	NASIK	Aurangabad Depot	970212	1332.48	92.92%
NORTH	ODISHA	Khorda	1840150	2576.21	92.75%
NORTH	SILIGURI	DC Fatapukur	578277	891.87	92.25%
SOUTH	VIJAYAWADA	Atmakuru	2034774	2513.7	91.84%
NORTH	EAST UP	Kanpur Co-pack Water	395458	625.1	91.69%
SOUTH	HYDERABAD	Ameenpur	2513167	3455.15	91.67%
WEST	GOA	Goa	165170	747	89.16%
NORTH	JAMMU	BB Depot	70672	567.9	88.60%
SOUTH	CHITTOOR	Srikalahasti	885760	1259.44	88.24%
WEST	RAJASTHAN	Kaladhera	729495	1509.3	88.17%
SOUTH	KARNATAKA	Bidadi Plant	86080	288	88.15%
WEST	RAJASTHAN	Udaipur Depot	202464	395.16	87.76%
NORTH	WEST UP	Dasna	3049662	5092.2	87.39%
WEST	MADHYA PRADESH	Bhopal	737334	1596.66	86.15%
SOUTH	TAMIL NADU	Gangaikondan Copack	233520	483.72	85.43%
SOUTH	KARNATAKA	Bangalore-Bidadi-DPG	2064650	3053.6	85.38%
NORTH	EAST UP	Kanpur Depot	455390	685.1	84.88%
NORTH	JAMMU	Jammu	37281	251.43	84.56%
SOUTH	TAMIL NADU	Coimbatore Depot	151041	519.39	84.37%
SOUTH	TAMIL NADU	Redhills Depot	700854	2100.12	84.14%
SOUTH	KERALA	Cochin Depot	76560	487.2	83.12%
SOUTH	TAMIL NADU	Nemam	227672	336.16	82.85%
NORTH	WEST UP	Jhilmil Depot	31416	292.74	81.87%
SOUTH	HYDERABAD	Himjal Copack	496384	941.8	81.82%
SOUTH	HYDERABAD	Maula Ali Depot	303606	781.56	81.46%
SOUTH	HYDERABAD	Bowrampet Depot - NKA	51756	358.66	80.85%
SOUTH	KARNATAKA	Bidadi Plant 2	158015	141.96	78.67%
SOUTH	KARNATAKA	Bharatiyam Copack	191820	248.4	76.17%
SOUTH	HYDERABAD	Bowrampet Depot - GT	104400	444	73.68%
SOUTH	KARNATAKA	South KP Road Depot	5894	189.45	44.62%

Measures in question:

Target Value  LBW = IF(
    ISFILTERED('Prototype Modeling_Freight'[Origin Name]),CALCULATE(VALUES('Prototype Modeling_Freight'[Target Test.LBW_Target])),
        IF(ISFILTERED('Prototype Modeling_Freight'[Plant Unit]),CALCULATE(VALUES('Prototype Modeling_Freight'[TArget Test_PU.LBW_Target_PU])),BLANK()))
        

Any commnet or suggestion is welcomed

TIA

@Anonymous 

@Greg_Deckler 

@nandukrishnavs 

[nandukrishnavs]

@Anonymous 

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 🙂

[Anonymous]

@nandukrishnavs 

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 · Accepted solution]

@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 🙂

[Anonymous]

@nandukrishnavs 

Thank you very much. rescued me again 🙂

[Anonymous]

What I mean by multiple selected values