Visualize at which point a threshold based on a cumulative measure is exceeded

[Jo_Swinnen]

Hi,

I've made a measure to calculate a cumulative percentage of column D based on column C. 

Output: 

Now we have a KPI which states that 95% of all the files need to be done within 10 days. I want to visualize in a table for each entity at which point this 95% is exceeded. For A you see in the above table this is at 10 days, for B it is at 11 days. Example of the output:

A     10

B      11

Can anyone help? Thanks,

Jo 

[Anonymous · Accepted solution]

Hi  @Jo_Swinnen ,

Here are the steps you can follow：

Create measure.

Measure =
var _sumall=SUMX(FILTER(ALL('Table'),'Table'[Entity]=MAX('Table'[Entity])),[Number of files])
var _sumcum=SUMX(FILTER(ALL('Table'),'Table'[Entity]=MAX('Table'[Entity])&&'Table'[Age]<=MAX('Table'[Age])),[Number of files])
return
DIVIDE(
    _sumcum,_sumall)

Flag =
IF(
    MAX('Table'[Age])=
MINX(FILTER(ALL('Table'),'Table'[Measure]>=0.95&&'Table'[Entity]=MAX('Table'[Entity])),[Age]),1,0)

Place [Flag]in Filters, set is=1, apply filter.

Best Regards,

Liu Yang

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

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...