Forum Discussion
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 ...
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.
Hi Greg_Deckler
Tried the suggested formula but it doesn't work. The 'Card' used actually produced 'Blank' as the 95th Percentile.