Measure filtered by slicer - group results by column value

[FlowViz]

Hi all,

I have a measure within my report which calculates the percentage of time items spent in 'active' states (as determined by what the user selects in the slicer). This gives a flow efficiency percentage Active Time / (Active Time + Wait Time).

I'm struggling with the measure for this for each individual WorkItemID, as it is giving the same answer for all, for example for 725:

It should actually be showing 3%, as that was the amount of time spent in 'active' states - 4 / (4 + 38 + 63 + 40) * 100

Anyone have any ideas as to hwo to fix this? Pbix is available here if it helps...

[KNP]

I had a look at the PBIX file. I don't have time right now to come up with a solution unfortunately, but I'm sure someone will have something for you shortly.

I like what you did with the navigation features you've built into the report. Those bookmarks must have taken forever. Especially the light/dark mode. I posted an idea a while back on the ideas site that you might like to vote for.

https://ideas.powerbi.com/ideas/idea/?ideaid=781638b4-9b86-eb11-8ced-281878e6452b

[FlowViz]

Thank you - yes it did take a while! Have upvoted your idea. Hopefully someone can help me out...

[KNP]

@FlowViz - I may have have put others off answering with my initial relply.

If (@BA_Pete, @AlexisOlson, @parry2k) you have time to look at this issue, the below is the measure in question in the PBIX file linked in the original question.

FE =
VAR _active =
    SUMX (
        FILTER (
            ALLSELECTED ( 'WorkItems FlowEfficiency' ),
            'WorkItems FlowEfficiency'[Column]
                IN VALUES ( slicer[WorkItems FlowEfficiency_Column] )
        ),
        'WorkItems FlowEfficiency'[Time in column (days)]
    )
VAR _all =
    SUMX (
        ALLSELECTED ( 'WorkItems FlowEfficiency' ),
        'WorkItems FlowEfficiency'[Time in column (days)]
    )
RETURN
    _active / _all

[AlexisOlson · Accepted solution]

@FlowViz I think the ALLSELECTED is removing more filter context than intended (plus you should never use that function inside of an iterator).

Try something simpler like this as a starting point:

FE =
VAR _active =
    CALCULATE (
        [Time in column (days)],
        FILTER (
            VALUES ( 'WorkItems FlowEfficiency'[Column] ),
            'WorkItems FlowEfficiency'[Column]
                IN VALUES ( slicer[WorkItems FlowEfficiency_Column] )
        )
    )
VAR _all = [Time in column (days)]
RETURN
    _active / _all

[FlowViz]

EDIT: thank you again, this is working just as I want it to 🙂