Forum Discussion
Young_G_Han
Helper III
Helper IIIvar return with Slicers.
Hi. There is a wall that I am facing, I tried to find a solution in your youtube video of Power BI contents creators but not yet having any solution. Please review my problem below and make a conte...
Right but you are still using VAR's and CALCULATE weird. Try this:
Quantity sold = CALCULATE( SUMX( sales, sales[quantity]), DATESYTD( date[date] ), FILTER( product, product[code] = "A") )The other option would be to take your 2 VAR's and turn them into their own measures, then what you are doing with the CALCULATE would make more sense.
amitchandak
Super User
Super UserThe only thing I can recommend now is var ProductFilter = FILTER(all( product), product[code] = "A")
If possible please share a sample pbix file after removing sensitive information.Thanks.
Proud to be a Datanaut My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Young_G_HanThank you for your advice.
But All filter is not working.......