Use measure scalar value of a calculated measure in Calculated Column.

[Max1968]

Hi All,

I'm dealing with this issue since a while and so far, I could not found a solutions,

I have calculated a Percentile as measure with the following formula that benefit of the slicer selection:

Percentile 70% = CALCULATE(PERCENTILE.INC(DistrictWorkload[Total Act Cost $ query],0.7),ALLEXCEPT('DistrictWorkload',DistrictWorkload[Model Number],DistrictWorkload[Parts Status],DistrictWorkload[System Type],DistrictWorkload[Billing Type Description],DistrictWorkload[Platform],DistrictWorkload[Service Description],DistrictWorkload[SC End of Work Month-Year]))

and I want to add the scalar results of “Percentile 70%” measure  in "DistrictWorkload" Table as a new Colum and the Value should be the same for each  row, I have now different percentile value in each of the row that is exactly the Total Act Cost $.

Thanks in advance,

Max

[Kedar_Pande]

You should:

1. Use the measure to display the percentile dynamically in visuals (like tables) based on your slicer context.
2. If you need a calculated column, you'd need to remove slicer interactivity, but this will not give the dynamic filtering based on slicers.

For your situation, it's best to continue using the Percentile 70% measure within your visuals to display the percentile value correctly across filtered data. A calculated column would be static and not react to slicers.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Max1968]

Thanks for the replying,

I can't remove the the slicer context because the percentile value should be used to acchive the following 

clusterization and so should be relative only to the selected models or system type in my case.

Actually I'm trying to create a Virtual Table that respond to the slicer selections to run the calculation within this table but so far I was not able to filter more than one model at time!

Regards

[lbendlin · Accepted solution]

Different from Tableau, Power BI does not support dynamic bucketing.  You need to prepare all possible buckets in a reference table, and then use measures to pick the desired ranges.

[Max1968]

Many thanks for the hints!

I'll start to work on it, if there is somewhere a pratical example please so kindly to share.

Regards

[lbendlin]

and I want to add the scalar results of “Percentile 70%” measure  in "DistrictWorkload" Table as a new Colum 

You cannot/should not create a calculated column from a measure.  It's technically possible but makes no sense as you are missing the filter context.

[Max1968]

Tks for replaying!

Yes you all rigth I'll miss the filter context but I'm just interested to fill a colum with the same scalar value.

For exsample if percentile value calculated is 1000 I jsut want to move the value in a colum for all row like when you create a measure. Measure=1000.

T

[danextian]

What do you mean by this?
For exsample if percentile value calculated is 1000 I jsut want to move the value in a colum for all row like when you create a measure. Measure=1000.

Measures in a calculated column will not respond to slicer selections. Their values will not chage unless the formula or the underlying data has been modified.

[lbendlin]

Still no.  You cannot meaningfully do that.