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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ssssss
Frequent Visitor

Transform a calculated column into a measure Dax

Hello,

 

I would like to turn this calculated column into a measure.

For information, the names of these following columns of the PM Global table come from other tables (they are not measures) : 

- Global groups

- Company Code

- Support

- Uoa Gaap

- Family

Calculated column =
IF ('PM Global'[Global groups] = "CATEGORY"&& 'PM Global'[Chaine] = "AIS"&&'PM Global'[Company Code] = "15FRA0001"&&'PM Global'[Support] = "2"&&'PM Global'[UOA_GAAP] = "2"&&'PM Global'[Family] = "RET ",

CALCULATE ([T cumul pour PM],'Référentiel comptes'[groupes global] = " CATEGORY ",'intermédiaire'[Support]="UC"||'intermédiaire'[Support]="Eurocroissance",'intermédiaire'[Chaine] = "AIS",'PM Global'[Code Société] = "15FRA0001",'intermédiaire'[Code Société (groupes)] = "French")-SELECTEDVALUE((Valeurs_ACAV[V_AIS]))

What I tried (column names appear in red, I only have access to the measurements :

Measure =
VAR IsMatching = 'PM Global'[Global groups] = "CATEGORY"
   && 'PM Global'[Chaine] = "AIS"
   && 'PM Global'[Company Code] = "15FRA0001"
   && 'PM Global'[Support] = "2"
   && 'PM Global'[UOA_GAAP] = "2"
   && 'PM Global'[Family] = "RET "
VAR IsInScope =
   ISINSCOPE ( 'PM Global'[Global groups] ) && ISINSCOPE ( 'PM Global'[Chaine] ) && ISINSCOPE ( 'PM Global'[Company Code] )
RETURN
   IF (IsInScope && IsMatching,
       CALCULATE ([T cumul pour PM],'Référentiel comptes'[groupes global] = "CATEGORY",'intermédiaire'[Support] = "UC" || 'intermédiaire'[Support] = "Eurocroissance", 'intermédiaire'[Chaine] = "AIS",'PM Global'[Code Société] = "15FRA0001",
'intermédiaire'[Code Société (groupes)] = "French" )- SELECTEDVALUE ( Valeurs_ACAV[V_AIS] ),
       BLANK ()
   )

Thank you !

1 REPLY 1
parry2k
Super User
Super User

@ssssss it will be easier if you paste some data with the expected output. 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.