Forum Discussion
IF/Or measure
Hi I'm trying to create an if formula that will select one of three measures (IA Target, AA Target or NLP Target) depeding on certain critea
Table: WFE; Column: Busness Unit & Title
If (WFE[Business Unit]="International", IA Target
But if the
IF(WFE[Business Unit]=America, &&(WFE[Title]= "Associate" or "Senior Associate", AA Target, NLP Target)
I'm not quite sure how to write the measure
Hii Anonymous ,
Please let me know whether the following measure helps you or not.
Target =IF (SELECTEDVALUE ( 'Table'[Bussiness Units] ) = "International","IA Target",IF (SELECTEDVALUE ( 'Table'[Bussiness Units] ) = "America"&& SELECTEDVALUE ( 'Table'[Title] ) = "Associate"|| SELECTEDVALUE ( 'Table'[Title] ) = "Senior Associate","AA Target","NLP"))I've got the folowing output :-
7 Replies
- Ritaf1983
Super User
Hi Anonymous
Try this :
if (Max(WFE[Business Unit])="International", IA Target,iF( max((WFE[Title])= "Associate") || max((WFE[Title])= "Senior Associate" && max(WFE[Business Unit])="America", AA Target, NLP Target) .
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly- Ritaf1983
Hi Anonymous
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523WFE Table
Business Units Title America Associate International
Senior Associate NLP Currently I have 3 different table to tell me the targets forr Associates or Senior Associates in America, NLP, and International Associates. Instead of having 3 different tables I would like to just have one.
Name Region Title Target A America Associate AA Target B America NLP NLP Target C International Senior Associate IA Target D America Senior Associate AA Target
Ritaf1983 It did not work I recieved the below error
Hii Anonymous ,
Please let me know whether the following measure helps you or not.
Target =IF (SELECTEDVALUE ( 'Table'[Bussiness Units] ) = "International","IA Target",IF (SELECTEDVALUE ( 'Table'[Bussiness Units] ) = "America"&& SELECTEDVALUE ( 'Table'[Title] ) = "Associate"|| SELECTEDVALUE ( 'Table'[Title] ) = "Senior Associate","AA Target","NLP"))I've got the folowing output :-
