主页 / coding / 问题 / 77460488
Accepted
Seyma Kalay
Asked: 2023-11-10 21:50:23 +0800 CST

如何在 DAX 中添加/减去两列值

  • 772

如何添加下面的代码更高效？提前谢谢了。

  Total Operating Profit = 
    
    var _totOther =
    CALCULATE(
        [mymeasure] 
        ,dimAccount[FS Header Description] = "Total Other Operating(Inc)/Exp")
    
    var _direct =
    CALCULATE(
        [mymeasure] 
        ,dimAccount[FS Header Description] = "Direct Overhead without Allocations")
    
    var _Result = _totOther  +  _direct 
    
    RETURN _Result


# table view 
 FS Header Description                       mymeasure
    + Total Other Operating(Inc)/Exp           5
    + Direct Overhead without Allocations      10

# Expected Result 
  5 + 10
powerbi

1 个回答

  1. Best Answer

    尝试这个：

    Total Operating Profit = 


    [Actuals - Currency]( 
    dimAccount[FS Header Description] IN {"Total Other Operating(Inc)/Exp", "Direct Overhead without Allocations"})
    • 1

相关问题