Forum Discussion

Jo_Swinnen's avatar
Jo_Swinnen
Frequent Visitor
3 years ago
Solved

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

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 ...
needhelp
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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