Adding a Summarized table in Power BI

SumT = SUMMARIZE(Details,Details[event_name],Details[Sales_Week],”Reg Count”, CALCULATE(SUM(Details[sales_quantity]),FILTER(Details,Details[CancelFlag]=”NO”)),”Cancel Count”, CALCULATE(SUM(Details[sales_quantity]),FILTER(Details,Details[CancelFlag]=”YES”)))

Leave a Reply

Your email address will not be published. Required fields are marked *