3 Replies Latest reply on Oct 11, 2018 10:33 AM by Hari Ankem

    Histogram | Comparing Distribution of Two Measures

    morton hsiao

      I've read this:

      Histogram | Comparing Distribution of Two Measures

      and

      https://kb.tableau.com/articles/howto/create-overlapping-histograms

       

      and made my own overlapping histogram, but I have two problems with it.

       

      My data looks like

       

      select value, 'g' as source from table 1

      union all

      select value, 'a' as source from table 2

       

      And I made my measures as

      aerr := if [source] = 'a' then value end

      gerr := if [source] = 'g' then value end

       

      So when I do the double histogram, the % of total number of records takes the total number of records as the denominator, not just the number of records where source equals g or a.  I think I may have to use a lod expression, which is of course easier than dax, but before I try, is this the way to go?