Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
TotalOpenOrderAmount1 = CALCULATE ([OrderAmount]-[ShippedAmount], ALL(CalendarDate), OrderLineDetail[Status]="Open") TotalOpenOrderAmount2 = CALCULATE ([OrderAmount]-[ShippedAmount], ALL(CalendarDate), Filter(OrderLineDetail,OrderLineDetail[Status]="Open") )
TotalOpenOderAmount1 can be measured as expected.
But TotalOpenOrderAmount2 is still affected by Calendar filters on the report.
Why is that? Can someone help to explain it?
hi @kanielwang
Try this. It's the equivalent of TotalOpenOrderAmount1
TotalOpenOrderAmount2 = CALCULATE ([OrderAmount]-[ShippedAmount], ALL(CalendarDate), Filter(ALL(OrderLineDetail[Status]),OrderLineDetail[Status]="Open") )
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
29 | |
14 | |
11 | |
10 | |
9 |