Forum Discussion

jordanxie's avatar
jordanxie
Icon for Helper I rankHelper I
5 years ago

Table Column with same value for each row on measure

Hi,   I have a measure for 95th Percentile based on SOL Created On date as below. Each row will have a different Demonstrated Lead Time but would like the 95th Percentile column to be the same for ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

jordanxie  I believe:

95th Percentile = PERCENTILEX.INC(
SUMMARIZE(ALL(Demonstrated_Lead_Time_1), Demonstrated_Lead_Time_1[SOL Created On] ),
CALCULATE(AVERAGE(Demonstrated_Lead_Time_1[Demonstrated Lead Time])),
0.95
)

Hard to say for certainty without sample data, etc. But you are going to want an ALL in there somewhere to break out of the context of the visual and consider all of the data.

jordanxie's avatar
jordanxie
Icon for Helper I rankHelper I
5 years ago

Hi Greg_Deckler 

 

Tried the suggested formula but it doesn't work. The 'Card' used actually produced 'Blank' as the 95th Percentile.