Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts,
Below is the DAX for Calculated Column, I would like to convert the same as DAX Measure. Can anyone Help me Please!!!
Thank you
Solved! Go to Solution.
I'd probably rewrite it something like this:
AUMBAND =
VAR CurrentPortfolio =
VALUES ( 'Financial Overview'[Portfolio] )
VAR CurrentFinPort =
FILTER (
'Financial Overview',
'Financial Overview'[Portfolio] IN CurrentPortfolio
)
RETURN
IF (
SELECTEDVALUE ( 'Financial Overview'[FinOverFinLevel1] ) = "Assets Under Management",
SUMX ( CurrentFinPort, 'Financial Overview'[Balance] )
)
@Anonymous If you post it as text, sure.
Hi Greg,
AUMBAND =
VAR CurrentPortfolio = 'Financial Overview'[Portfolio]
VAR CurrentFinPort =
FILTER('Financial Overview','Financial Overview'[Portfolio] = CurrentPortfolio)
Return
IF('Financial Overview'[FinOverFinLevel1] = "Assets Under Management",
SUMX(CurrentFinPort,'Financial Overview'[Balance]))
I'd probably rewrite it something like this:
AUMBAND =
VAR CurrentPortfolio =
VALUES ( 'Financial Overview'[Portfolio] )
VAR CurrentFinPort =
FILTER (
'Financial Overview',
'Financial Overview'[Portfolio] IN CurrentPortfolio
)
RETURN
IF (
SELECTEDVALUE ( 'Financial Overview'[FinOverFinLevel1] ) = "Assets Under Management",
SUMX ( CurrentFinPort, 'Financial Overview'[Balance] )
)
@Anonymous Wrap your column references in an aggregation like MAX or SUM, etc.
Hi Greg,
Thank you for your quick reply. Could I trouble to convert it as a measure, Please!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |