March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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 !
@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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |