我有一张看起来像这样的桌子
I have a table that looks like this
| Date | Total | Loss | |---------------------|---------|--------| | Jan 1 2018 | 90 | 5 | |---------------------|---------|--------| | Jan 3 2018 | 10 | 5 | |---------------------|---------|--------| | Feb 1 2018 | 50 | 5 | |---------------------|---------|--------| | Feb 3 2018 | 50 | 10 | |---------------------|---------|--------|我希望能够在表格中显示总"损失"的百分比取决于时间段.
I wanna be able to show in a table how much percentage of "Total" "Loss" is depending on the period.
例如,如果在我的仪表板中我将表格可视化器显示为月份,它应该给出:
For example if in my dashboard I show the table visualizer as months, it should give :
| Date | Loss % | |---------------------|---------| | Jan 2018 | 10% | |---------------------|---------| | Feb 2018 | 15% | |---------------------|---------|但是如果我把它显示为年份,它应该给出:
But if I show it as year, it should give :
| Date | Loss % | |---------------------|---------| | 2018 | 12.5% | |---------------------|---------|现在我找到的唯一解决方案是在数据"选项卡中创建表格,以汇总每个月的主表格.但这对我来说不是一个永久的解决方案(我最终有太多的表,因为我必须为许多不同的列和相互冲突的关系做那种表).
Right now the only solution I have found is to create tables in the Data tab that would sum up my main table for each Month. But that can't be a permanent solution to me (I end up with too many tables, as I have to do that kind of table for many different columns and conflicting relationships).
推荐答案我通过将以下度量添加到您的表中获得了相同的结果 LossPercent = 100 * SUM(SalesData[Loss])/SUM(SalesData[Total]),然后添加日期和日期表之间的关系,其中包含将日期细分为要显示的分组.
I achieved the same result by adding the following measure to your table LossPercent = 100 * SUM(SalesData[Loss]) / SUM(SalesData[Total]), then adding a relationship between the date and a Dates table, which contains a breakdown of dates into the groupings you want to display.
更多推荐
在 Power BI 中显示为另一列的百分比
发布评论