Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello community,
I'm having issues using numeric columns from the tabular model created in Visual Studio as a measure in the Value field box. The vizualisation doesn't allow me to drag and drop the column inside the box:
To solve this I need to create a calulated measure of all my calculated/numeric columns for example Invoiced Amount = SUM([Invoiced Amount column]) which means that I have to rename all the calculated columns since they cannot have the same name. This solution feels utterly bad... but I haven't found another solution yet. I did come across this post:https://community.powerbi.com/t5/Desktop/Can-t-directly-use-most-of-my-fields-from-analysis-services...
where they suggest to set "discourageImplicitMeasures" property to false inside Tabular Editor but there doesn't seem to be that option inside Visual Studios..
Solved! Go to Solution.
You can avoid renaming columns if you create measures in a measure table:
Creating explicit measures is a best practice that is worth the effort. Implicit measures have limitations. For example, the function SELECTEDMEASURE (used extensively in calculation groups) doesn't work with implicit measures.
Proud to be a Super User!
You can avoid renaming columns if you create measures in a measure table:
Creating explicit measures is a best practice that is worth the effort. Implicit measures have limitations. For example, the function SELECTEDMEASURE (used extensively in calculation groups) doesn't work with implicit measures.
Proud to be a Super User!
Thank you @DataInsights !
I'm still curious though where the "discourageImplicitMeasures" is located inside Visual Studio.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
95 | |
69 | |
44 | |
38 | |
30 |
User | Count |
---|---|
157 | |
101 | |
60 | |
42 | |
40 |