Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Table with repeated categories and empty values.

I am trying to build a table that includes the categories of different dimensions (dimfecha, dimproducto, dimtienda, etc.) and of several madidas of the sales data table (factSales). This table I intend to analyze by applying filters with slicers from the categories of the dimentions, but by integrating the fields of the dimentions and measures in the same table, the rows expand for each category of each dimencion and shows many empty values instead of only showing the rows for which there are values. All dimensions are connected to the factSales by a relation several to one (* : 1) . It is necessary to change the type of relationship or something is missing from the measures..??

gescobarmaya_0-1648278909840.png --> gescobarmaya_1-1648279021617.png

3 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    Can you check if any of the fields have the option "Show Items with no data" enabled?

     

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      Hello
      No, none of the categories I have added of the dim (dates, products or customers) have that option enabled.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi Syndicate_Admin ,

    You can check when you don't put the measure in the table, if the table shows correctly, it's a problem with the measure.

    For further help, need more information about your data model and formula.

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.