Measure to Calculate Percentage
Hi Team, Good day, all, I am trying to calculate a percentage of data using a measure in the matrix table format. Vendor Name the Row, In the values, I have M category and M %(this is the field I am trying to work) While I am trying this in the matrix table option in the report, I couldn't able to bring the M category total value divided by the particular M Category. Because the same M category is used in the column, the total value is categorized in the M % calculation. It is stopping me from pursuing further. Any ideas are highly appreciated, thanks. Thanks ShaGuna
DAX
l am trying to use below VAR value in the Calculate function but not working LY YTD Sales = VAR MM=month(Max(SalesDataDates)) -- store max date from sales data table VAR YY=Year(Max(SalesDataDates)) -- store max Year No from sales data table Return Calculate(CY YTD Sales, dateTable[MonthNo]<=MM&&dateTable[YearNo]<=YY) Somebody please help
