Why does Values shows blank row even if there are none?

[HarsimPWRBI]

Hey Tech buddies,

I'm reading the-definitive-guide-to-dax and in Chapter 3 FIGURE 3-15  has a pivot table.

Which shows 1 for column "Values Products" with "Sales Amount" of $16.90.

The Reason It states , is there are sales for product for which there's no data in Product table.

But If i go to database and execute below query there's no rows like same.

USE ContosoRetailDW
GO

SELECT * FROM [DaxBook].[Sales] a
WHERE NOT EXISTS (SELECT 1 FROM [DaxBook].[Product] b WHERE a.ProductKey=b.ProductKey)

Moreover i tried to rollup in database but there i got only three rows for class with their aggregrate Sales Amount

SELECT b.Class, SUM(a.Quantity*a.[Unit Price]) AS SalesAmount FROM [DaxBook].[Sales] a
right JOIN DaxBook.Product b
ON a.ProductKey=b.ProductKey
GROUP BY b.Class

Please suggest.

Database and PowerBI Model for same

Thanks,

Harry

[v-yulgu-msft]

Hi @HarsimPWRBI,

It would be better that you could provide some sample data to describe the problem. How to Get Your Question Answered Quickly

Besides, for any errata you find, you could contact the related team via the "report it to us" link.

Best regards,

Yuliana Gu

[HarsimPWRBI]

Hi @v-yulgu-msft,

As recommended I've added Database and PowerBI model for my query related to same.