Forum Discussion
Filters won't work for visuals from calculated tables
Hi danextian, I just figured out how to calculate that. Firstly, I created a measure to calculate the ActiveDays/PolicyCount for each date and bucket. Next, I transformed the diagonal values into row values by using a new row index. Finally, I used the DAX "SUMX(VALUES(Table[date]), [Measure])" to calculate the SUM of each row and got what I need. Thanks, though. :smileyhappy:
Super User
Hi dralexandero, Not sure if this is the solution you're looking for but this might help.
https://drive.google.com/open?id=14tCau_ehtEA6606v2sJHOC2tEUpn27tz
Hi danextian, I just figured out how to calculate that. Firstly, I created a measure to calculate the ActiveDays/PolicyCount for each date and bucket. Next, I transformed the diagonal values into row values by using a new row index. Finally, I used the DAX "SUMX(VALUES(Table[date]), [Measure])" to calculate the SUM of each row and got what I need. Thanks, though. :smileyhappy: