英文:
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 (表格,表格[员工],"总利用率", [总利用率（%）])RETURNMEDIANX (T1,[总利用率])
英文:
Try this measure:
=VAR T1 =SUMMARIZE (Table,Table[Employee],"Total Utilization", [Total Utilization (%)])RETURNMEDIANX (T1,[Total Utilization])
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论