Conditions for Columns

Question

Hi All,&nbsp;I have senario like below table&nbsp; .&nbsp;&nbsp;Main Table&nbsp;SNO&nbsp; &nbsp; &nbsp; MG&nbsp; &nbsp; &nbsp; MU&nbsp; &nbsp; &nbsp; MP&nbsp; &nbsp; &nbsp;LG&nbsp; &nbsp; &nbsp; LU&nbsp; &nbsp; &nbsp; &nbsp;Percentage1&nbsp; &nbsp; &nbsp; &nbsp; Percentage21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XX&nbsp; &nbsp; &nbsp; &nbsp;AA&nbsp; &nbsp; &nbsp; &nbsp;BB&nbsp; &nbsp; &nbsp; CC&nbsp; &nbsp; &nbsp; DD&nbsp; &nbsp; &nbsp; &nbsp;80%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75%2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XX&nbsp; &nbsp; &nbsp; &nbsp;AA&nbsp; &nbsp; &nbsp; &nbsp;BB&nbsp; &nbsp; &nbsp; CC&nbsp; &nbsp; &nbsp; DD&nbsp; &nbsp; &nbsp; &nbsp;75%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75%&nbsp;Bridge Table&nbsp;Sno&nbsp; &nbsp; &nbsp;Group&nbsp; &nbsp; &nbsp; Attributes1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XX2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XX3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MU&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AA4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MU&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AA5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MP&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BB6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MP&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BB7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CC8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CC9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LU&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DD10&nbsp; &nbsp; &nbsp; &nbsp; LU&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DD&nbsp;Based on the SNO created relationship. So far it's fine.&nbsp; Now Group column from the bridge table used in the slicer.&nbsp;In the slicer it's coming like&nbsp;MGMUMPLGLU&nbsp;In Table visual i have used GROUP and&nbsp; Attributes&nbsp;columns from the Bridge table. Table will be look like below&nbsp;Group&nbsp; &nbsp; &nbsp; Attributes&nbsp; &nbsp; &nbsp; Calculated values&nbsp;MG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXMG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXMU&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AAMU&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AAMP&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BBMP&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BBLG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CCLG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CCLU&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DDLU&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DD&nbsp;Now If i select MG or MP or MU from slicer it should display Percentage 1 valuesIf i select LG&nbsp;or LU&nbsp;&nbsp;from slicer it should display Percentage 2 values in the calculated column as i mentioned above table.&nbsp;&nbsp;I hope it's clear. Is it possible in Power BI, If yes colud u plese let me know.&nbsp;Thanks&nbsp;

tahreem24 · Answer

harib&nbsp;,&nbsp;Create calculated column like below:Column 1&nbsp; = if(OR(HASONEVALUE(Sheet7[MG]),HASONEVALUE(Sheet7[MU])),"Yes")Column2 = if(OR(HASONEVALUE(Sheet7[LG]),HASONEVALUE(Sheet7[LU])),"No")&nbsp;Please give Thumbs up for support and accept this as a solution if it helps you!

harib · Answer

Tahreem24&nbsp;If i would like to add one more column (MP), when i add MP Column, syntax is showing wrong. Can u pls let me know.&nbsp;Thanks

tahreem24 · Answer

harib&nbsp;,&nbsp;What would be the business logic for MP column?&nbsp;Thanks!

anonymous · Answer

"I woluld like to give condition like if it is MG, MU then in column1 it should come Yes , if it is LG, LU then in column 2 it should come No. "

Can you clarify?

If MG=MU?

I guess that you're showing an actual table (and not a visual), so you can do that either in PowerQuery M or in DAX. Both solutions are equivalent.

I would do

Column1=IF(Table[MG]=Table[MU];"Yes")

but you first need to clarify the question

harib · Answer

Updated the Requirment. Can u please give me the solution.

Forum Discussion

Conditions for Columns

8 Replies

Related content

Conditional Column with Multiple Conditions

Conditional column

Conditional Column with Multiple Conditions

Conditional Column in power query

Conditional Column Creation