英文:
Get the median of a Power BI measure
问题
如何在Power BI DAX中计算度量的中位数？
我有一个度量值[Total Utilization (%)]，我想要获取它的中位数。但看起来我只能对列使用Median。
示例数据集：
英文:
How can I calculate the median of a measure in Power BI DAX?
I have a measure [Total Utilization (%)], and I want to get its median. But it looks like I can only use Median for columns
Sample Dataset:
答案1
得分: 0
尝试这个 测量：
=
VAR T1 =
SUMMARIZE (
表格,
表格[员工],
"总利用率", [总利用率（%）]
)
RETURN
MEDIANX (
T1,
[总利用率]
)
英文:
Try this measure:
=
VAR T1 =
SUMMARIZE (
Table,
Table[Employee],
"Total Utilization", [Total Utilization (%)]
)
RETURN
MEDIANX (
T1,
[Total Utilization]
)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论