Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I'm trying to use a calculate formula to sum our out going per payment terms. The formula i'm using is
CALCULATE(SUM('supplier pymt data'[Supplier Amount]),Table1[payment category]),
but i'm getting the following error message in relation to payment category
Cannot convert value '0.1 Pre payment' of type Text to type True/False.
Solved! Go to Solution.
Try a measure like
total = CALCULATE ( SUM ( 'supplier pymt data'[Supplier Amount] ), FILTER ( 'supplier pymt data', CONTAINS ( Table1, Table1[payment category], 'supplier pymt data'[payment category] ) ) )
Try a measure like
total = CALCULATE ( SUM ( 'supplier pymt data'[Supplier Amount] ), FILTER ( 'supplier pymt data', CONTAINS ( Table1, Table1[payment category], 'supplier pymt data'[payment category] ) ) )
Dax isn't my native language, but I'm pretty sure that CALCULATE is a function where you filter the table results for a specific value. The error is telling that you it can't evaluate your filter expression for the CALCULATE function. A good site to use for DAX Expressions is here and a definition for CALCULATE is below.
CALCULATE(<expression>,<filter1>,<filter2>…) | Evaluates an expression in a context that is modified by the specified filters. |
Nate
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
86 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
110 | |
97 | |
71 | |
67 |