Forum Discussion

watje255_ju's avatar
watje255_ju
Helper III
3 years ago
Solved

Using ALL filter creates blank rows

COGS TEST HB.pbix link to PBIX file Hello, I have two fact tables, one with all the sales and customer data, and one which I am using to pull the COGS. There is no direct link between the two tabl...
  • rautaniket0077's avatar
    rautaniket0077
    3 years ago

    Hi watje255_ju ,

     

    Try replacing date from dimdate with date from factsales and format it as "Mmm yyyy"

some_bih's avatar
some_bih
Community Champion
3 years ago

Hi watje255_ju in you measure COGS PU, underling table is COGS. In this table there are no data for December 2022 for SKU 20 ORDER HB, see picture below. SKU 21 for this details have data. Hope this help