Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Solved! Go to Solution.
@AlejoGarzonE Measure for the field circled in red:
MacroprocessesThatApplicationsUse =
VAR codigo_app = SELECTEDVALUE('Transformed Mother Table'[Application Code])
RETURN
IF(
ISBLANK(codigo_app),
"Enter an application code to view information.",
CONCATENATEX(
FILTER(
'Transformed Macroprocesses Table',
'Transformed Macroprocesses Table'[ID] IN VALUES('Transformed Mother Table'[Macroprocesses that use the application])
),
'Transformed Macroprocesses Table'[Business Macroprocess Name],
UNICHAR(10)
)
)
New measure to combine the values:
CombinedMeasure =
VAR macroprocesses = [MacroprocessesThatApplicationsUse]
VAR otherMeasure = [YourOtherMeasure] -- Replace with the actual measure name
RETURN
IF(
ISBLANK(macroprocesses) || ISBLANK(otherMeasure),
"Data is missing.",
macroprocesses & UNICHAR(10) & otherMeasure
)
Proud to be a Super User! |
|
@AlejoGarzonE Measure for the field circled in red:
MacroprocessesThatApplicationsUse =
VAR codigo_app = SELECTEDVALUE('Transformed Mother Table'[Application Code])
RETURN
IF(
ISBLANK(codigo_app),
"Enter an application code to view information.",
CONCATENATEX(
FILTER(
'Transformed Macroprocesses Table',
'Transformed Macroprocesses Table'[ID] IN VALUES('Transformed Mother Table'[Macroprocesses that use the application])
),
'Transformed Macroprocesses Table'[Business Macroprocess Name],
UNICHAR(10)
)
)
New measure to combine the values:
CombinedMeasure =
VAR macroprocesses = [MacroprocessesThatApplicationsUse]
VAR otherMeasure = [YourOtherMeasure] -- Replace with the actual measure name
RETURN
IF(
ISBLANK(macroprocesses) || ISBLANK(otherMeasure),
"Data is missing.",
macroprocesses & UNICHAR(10) & otherMeasure
)
Proud to be a Super User! |
|
Which should I display in my visual object so that all the other data and the added macroprocess data can be seen?
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
103 | |
63 | |
45 | |
37 | |
35 |