5 Replies Latest reply on Apr 15, 2013 7:51 AM by Richard Zapata

    Counting rows in Dimensions not in the Fact

    Richard Zapata

      We have a table named "dealer_dim" which is joined to the fact (event_fact) on its ID.  We need a calculation that has the total number of dealers (including those not in the fact), but every time we COUNTD on the dealer name, it only returns the number of dealers contained in the fact.  How can I get the total count to use in a calculation including the ones NOT in the fact.

       

      So, for example, if my fact is EVENTS, and I want to see the number of DEALERS who are in EVENTS (e.g. 500) divided by the total number of DEALERS (e.g. 1000) so that we can build a calculation for % of participating dealers (50%)