AccountNum is not a measure..

Posted on May 28 2014 in Tableau & Microsoft Dynamics

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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>