'Month field is not getting drill down in power bi

I am calculating total revenue over the years. There are two tables calendar and sales. I have calculated total revenue using DAX now I want to display total revenue in each year.

The month field is not getting filtered for the Revenue column, I have attached a snip for reference.

Total revenue(DAX)= total revenue = SUMX(AW_Sales,AW_Sales[OrderQuantity] * RELATED(AW_Products_Lookup[ProductPrice]))

powerbi dax

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Month field is not getting drill down in power bi

Sources

Related Questions