Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a report with the following measure
Solved! Go to Solution.
@Anonymous When using measures, references to columns have to include an aggregation function like SUM, MIN, MAX, etc. This is a big difference from calculated columns. Calculated columns have row context and so do not need aggregation functions to reference other columns because the default is to get the value in the column for the same row.
Both are imports - one is from a odbc connection to a database.. the other is from an excel table.
In the end I made it a calculated column.. strange behaviour though!
@Anonymous When using measures, references to columns have to include an aggregation function like SUM, MIN, MAX, etc. This is a big difference from calculated columns. Calculated columns have row context and so do not need aggregation functions to reference other columns because the default is to get the value in the column for the same row.
My error - was initially a calculated column.. been a long day
@Anonymous So is this via a Live connection to the dataset or Direct query for Power BI datasets or are they both import models? Also, if this is really a measure and not a calculated column, you should need an aggregation function around the column reference (INVOICE[INVOICE_DATE])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |