Running total % with visual as page filter

[Bernd]

I have a running total % measure that works in a table as expected:

Account	Value	Cumulative Total	Cumulative Total %	Threshold measure
B	25	25	37%	TRUE
C	23	48	71%	TRUE
A	13	61	90%	FALSE
D	7	68	100%	FALSE

For the calculation I use the following DAX expressions:

Cumulative Total % = 
DIVIDE (
    IF (
        NOT ( ISBLANK ( [Total Value] ) ),
        CALCULATE (
            [Total Value],
            FILTER ( ALL ( 'Table'[Account] ), SUM ( 'Table'[Value] ) <= [Total Value] )
        )
    ),
    [Overall Value]
)

Threshold measure = [Cumulative Total %] <= 0.8

 I want to filter my page on those accounts that make up up to 80% of the total value (marked with TRUE).

However I only managed to set this correctly on the visual level filter for the table. I cannot add this measure as a page filter. Final goal would be to provide a visual so I can add this to a dashboard on PBI services.

Any idea whether/how this is possible?

[v-ljerr-msft · Accepted solution]

Hi @Bernd,

It is now possible to add a measure to Page Level Filter currently. However, the calculate column can be added to Page Level Filter. So I would suggest you to create a calculate column for "Threshold measure" in your scenario, then you should be able to put it to Page Level Filter.

Regards

[Bernd]

---

---

Thanks @v-ljerr-msft for the clarification.

I tried to convert the measure into a calculated column, but without success.

Can you help me with a corresponding DAX expression that would do the trick? Just "wrapping" the measure to make it work in a row-context does not return the % as needed.