Hi all Here is a screen recording to my problem statement Sample Data: Plant ClusterPlant UnitOrigin NameTarget Test.LBV_targetTarget Test.LBW_TargetLoadability WeightedNORTHBIHARPurnia Depot718320964.3297.91%NORTHNORTH EASTFatuha Depot7730911220.6797.03%NORTHODISHARourkela Depot225762374.3697.00%NORTHODISHAKhurda Depot285980383.1596.02%NORTHBIHARPatna Depot4703531235.7895.74%NORTHNORTH EASTGourpuri Depot5866021182.8695.09%NORTHJHARKHANDRanchi New Depot6797281140.7295.02%WESTPUNEKolhapur Depot84564155.5294.69%SOUTHVIZAGVizag Depot477480671.2494.15%NORTHSILIGURIAsansol Depot96855156.7593.94%WESTNASIKAurangabad Depot9702121332.4892.92%NORTHODISHAKhorda18401502576.2192.75%NORTHSILIGURIDC Fatapukur578277891.8792.25%SOUTHVIJAYAWADAAtmakuru20347742513.791.84%NORTHEAST UPKanpur Co-pack Water395458625.191.69%SOUTHHYDERABADAmeenpur25131673455.1591.67%WESTGOAGoa16517074789.16%NORTHJAMMUBB Depot70672567.988.60%SOUTHCHITTOORSrikalahasti8857601259.4488.24%WESTRAJASTHANKaladhera7294951509.388.17%SOUTHKARNATAKABidadi Plant8608028888.15%WESTRAJASTHANUdaipur Depot202464395.1687.76%NORTHWEST UPDasna30496625092.287.39%WESTMADHYA PRADESHBhopal7373341596.6686.15%SOUTHTAMIL NADUGangaikondan Copack233520483.7285.43%SOUTHKARNATAKABangalore-Bidadi-DPG20646503053.685.38%NORTHEAST UPKanpur Depot455390685.184.88%NORTHJAMMUJammu37281251.4384.56%SOUTHTAMIL NADUCoimbatore Depot151041519.3984.37%SOUTHTAMIL NADURedhills Depot7008542100.1284.14%SOUTHKERALACochin Depot76560487.283.12%SOUTHTAMIL NADUNemam227672336.1682.85%NORTHWEST UPJhilmil Depot31416292.7481.87%SOUTHHYDERABADHimjal Copack496384941.881.82%SOUTHHYDERABADMaula Ali Depot303606781.5681.46%SOUTHHYDERABADBowrampet Depot - NKA51756358.6680.85%SOUTHKARNATAKABidadi Plant 2158015141.9678.67%SOUTHKARNATAKABharatiyam Copack191820248.476.17%SOUTHHYDERABADBowrampet Depot - GT10440044473.68%SOUTHKARNATAKASouth KP Road Depot5894189.4544.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 welcomedTIA Anonymous Greg_Deckler 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 🙂

Anonymous

Not applicable

6 years ago

Solved

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

dax measure

Help with DAX Measure

isfiltered

Urgent Help with DAX

nandukrishnavs
6 years ago
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 🙂

5 Replies

nandukrishnavs
Community Champion
6 years ago
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
  Not applicable
  6 years ago
  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
    Community Champion
    6 years ago
    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 🙂

Forum Discussion

Target values with ISFILTERED

5 Replies

Related content

ISFILTERED multiple values

IsFiltered with multiple return values

KPI showing incorrect target value

ISFILTERED returning true value

Target Value KPI Targets