Tuesday, 27 July 2021

Power BI – To get the total of matrix or table

 Power BI – To get the total of matrix or table 

Number of tickets total:=CALCULATE(DISTINCTCOUNT('SSOT_DM FactSales'[Cross Cat Ticket]),ALLSELECTED('Ticket Count4'[Category2]),ALLSELECTED('SSOT_DM FactSales')) 

No comments:

Post a Comment