The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I have transactions measure that just shows transactions. I need to create measure that uses existing transactions measure but ignores Product Is Gift Card filter but not date or any other filters.
This is the filter.
Thanks.
Solved! Go to Solution.
Please try this
CALCUALTE ( [Measure] , REMOVEFILTERS ( Table[Product is Gift Card] ) )
Please try this
CALCUALTE ( [Measure] , REMOVEFILTERS ( Table[Product is Gift Card] ) )
@AntonioM It looks to be working fine for now. Numbers looks ok but will need more checking to be sure that they are correct.