Using getpivotdata equivalent in Power BI

[akhaliq7]

I have this formula in excel and I need to use the equivalent in Power BI using DAX: 

=GETPIVOTDATA("Count of Sales Year",$A$3,"Product Available Date",2022,"Product","bikes")

+ GETPIVOTDATA("Count of Sales Year",$A$3,"Product Available Date",2022,"Product","toys") 

+ GETPIVOTDATA("Count of Sales Year",$A$3,"Product Available Date",2022,"Product","clothes")

[akhaliq7 · Accepted solution]

Count of Sales Year =
COUNTX(FILTER(SALES, SALES[Product Available Date] = "2022" && SALES[Product] = "Bike"),
[Sales Year]
)
+ COUNTX(FILTER(SALES, SALES[Product Available Date] = "2022" && SALES[Product] = "Toys"),
[Sales Year]
)
+ COUNTX(FILTER(SALES, SALES[Product Available Date] = "2022" && SALES[Product] = "Clothes"),
[Sales Year]
)