Tableau automatically classifies your data based on whether it contains categorical data (dimensions) or quantitative data (measures).
A measure is quantifiable, like sales, or item quantities. Dimensions are used to slice measures. For example, sales by quarter, or sales by region.
Usually, I think Tableau is pretty good at guessing correctly if an AX field contains a dimension or a measure, but for some reason AccountNum ends up as a measure if I for example import VendTrans:
Fortunately, it is not the big problem, you can simply drag AccountNum from the measures area and drop it in the dimensions area. Or you can right-click on AccountNum and convert to dimension:
no comments