Counting null Values

[dhavcog]

i want to count data even when it is null,  my data is coming from dimension,, now i want simple cross tab for how many claims new registered this month and last month,, but problem, if there is no data for the particular month ,, count want show on the cross tab,, i know the work around i need to create two separate queries ,one is for column and one is for measure,, but my column also static, for example i have two values for column this month and last month,, how i can design one query item with two static values and then outer join with measure so it will display count for null values regardless of data.. if any one can help me please,, thanks,
dahval

[rockytopmark]

Use a join query, where the left query is your dimension information only and the right query has the dimension join item(s) and measure information.  The cardinality of join on the left would be 1..1 and on right 0..N

In the query's list of items, use the Dimension query items for everything dimensional, and use coalesce on the measure, to ensure there is a 0 returned even when NULL.

coalesce([your measure],0)