Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Simple model not doable?

We have a very simple model with Partners, PartnerSales, PartnerRebates (see below). There is also an MyCal = CALENDARAUTO() table for filtering calendar - related data.   What we need to see...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous whatever measure you are using add zero to it and it will force the measure to return zero value instead of blank() which is the reason that rows are not showing up, so for example measure will look like this

 

My Measure = SUM ( Table[Column] ) + 0
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    This example is about creating a pivot table, it does not involve any measures