Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Nick03
New Member

URGENT- IF statement or SWITCH in a Live connection-Finding it difficult to create this requirement.

Hello Power BI Family,

 

I am new here and please, I really need your help.

I have a report with a LIVE CONNECTION to the data sources. Due to this form connection, I dont have access to the data table in Power BI and I can't also create a CALCULATED COLUMN. I am left with just working with MEASURES. Below is a requirement that i am finding it difficult to create with  a measure.  I am to create a measure with the information below:

------------------------

If ManualFile = RETAIL or DRIVE and if QualifMONO = INTRA, then display INNO1

if ManualFile = CAT  and if QualifPAN = ICAN, then display INNO2 

if ManualFile = PMT and if QualifPMT = PRIO, then display INNO3

if ManualFile = ICE and if QualifMENTRA = MENTS, then display INNO4 

-----------------------

Since I can't create a calculated column due to the Live Connection, Is there any way I can do this with DAX measures? 

Please, I really need your suggestions and solutions to this problem.

 

Thanks in advance.

 

 

 

 

 

 

1 ACCEPTED SOLUTION

you already indicated that you cannot use calculated columns. Measures require aggregators. Not sure what else to say.

 

Note:  You need to protect your "OR" conditions because "AND" takes precedence. Alternatively use IN

 

MEASURE Name :=
SWITCH(TRUE(),
max(ManuelFile_FDV) IN { "Retail" ,"Drive"} && max(QualifMono) = "Innos Pro", 'Inno RS",
max(ManuelFile_FDV) = "XCAT" && max(QualifProxi) = "Innos Prio", 'Inno Proxi",
max(ManuelFile_FDV) = "PMT" && max(QualifPMTAuto) = "Innos Prio", 'Inno PMT",
max(ManuelFile_FDV) = "IC" && max(InnosMetro) = "Innos Prio", 'Inno Metro"
)

 

 

View solution in original post

4 REPLIES 4
Nick03
New Member

Thanks alot @Ibendlin.

lbendlin
Super User
Super User

Measures require aggregators.  You need to provide more details on how you want to display the final result before we can suggest which of them to use.

Thanks so Ibendlin for your kind reply.

 

I am actually trying to create a single column with the 4 conditions above met. All the datasets involved are categorical. Below is what I am trying to do using the MEASURE but it doesn't work.

Column Name =
SWITCH(TRUE(),
ManuelFile_FDV = "Retail" || ManuelFile_FDV = "Drive" && QualifMono = "Innos Pro", 'Inno RS",
ManuelFile_FDV = "XCAT" && QualifProxi = "Innos Prio", 'Inno Proxi",
ManuelFile_FDV = "PMT" && QualifPMTAuto = "Innos Prio", 'Inno PMT",
ManuelFile_FDV = "IC" && InnosMetro = "Innos Prio", 'Inno Metro",
BLANK()
)

I hope this will explain the problem more.

you already indicated that you cannot use calculated columns. Measures require aggregators. Not sure what else to say.

 

Note:  You need to protect your "OR" conditions because "AND" takes precedence. Alternatively use IN

 

MEASURE Name :=
SWITCH(TRUE(),
max(ManuelFile_FDV) IN { "Retail" ,"Drive"} && max(QualifMono) = "Innos Pro", 'Inno RS",
max(ManuelFile_FDV) = "XCAT" && max(QualifProxi) = "Innos Prio", 'Inno Proxi",
max(ManuelFile_FDV) = "PMT" && max(QualifPMTAuto) = "Innos Prio", 'Inno PMT",
max(ManuelFile_FDV) = "IC" && max(InnosMetro) = "Innos Prio", 'Inno Metro"
)

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.