Using Measure as Paramter

[JernbergMagnus]

** TAKING TIPS **

Hi,

I'm trying to use a measure as a parameter for my stacked column chart, and not succeding with this.

The Measure Backlog Grouped is only showing up as Load in my chart when using this Measure as a Parameter:

Backlog Grouped = 
IF (
    NOT ISBLANK(MIN('Manning_v'[Type])),
    IF (
        MIN('Manning_v'[Type]) = "Project",
        "Backlog",
        SELECTEDVALUE('Projects_v'[Name], "")
    ),
    BLANK()
)

The Paramter list looks like this:

Display By = {
    ....
    ("Backlog Grouped", NAMEOF('_DAX'[Backlog Grouped]), 6),
    ....
}

To me it looks like the NAMEOF is the issue, because the Measure shows as intended when using a Table Visualization.

BR

[Anonymous · Accepted solution]

Hi @JernbergMagnus ,

Please try the following methods and check if they can solve your problem:

1.The name of function is typically used to reference the name of a column, using this within a parameter might not be expected.

2.Considering revising the approach to parameter.

Implement data translation using field parameters - Power BI | Microsoft Learn

3.You can also view the following link to learn more information.

Solved: Create a dynamic measures using field parameter me... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.