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 All
I am able to flag Customer/Vendor Code from AR Table , using below measure :-
My PBI file :-
Paul
Solved! Go to Solution.
Hi Paul,
That error is generated when you are trying to create a Measure and haven't provided an aggregation (like MAX) for the column. Or you tried to create the column in the wrong table.
If you create the column in the Sales table then it works. Is this what you want?
_FLAG TOP_SALES = IF ( ( SALES[CUST_ID] IN { "A10002" } ), 1, 0)
Regards
Phil
Proud to be a Super User!
Hi Paul,
That error is generated when you are trying to create a Measure and haven't provided an aggregation (like MAX) for the column. Or you tried to create the column in the wrong table.
If you create the column in the Sales table then it works. Is this what you want?
_FLAG TOP_SALES = IF ( ( SALES[CUST_ID] IN { "A10002" } ), 1, 0)
Regards
Phil
Proud to be a Super User!
i learn one more new thing , the field i want to create need to create at SALES table .
Paul
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |