Forum Discussion

rachaelwalker's avatar
rachaelwalker
Resolver III
1 year ago

percentage using values from two different tables

I have two tables Projects and Warranty Tickets. I need to calculate the percentage of projects that have had a warranty ticket opened against it. In some cases, there are multiple tickets but I dont...
"Need Help"
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi lbendlin ,thanks for the quick reply, I'll add more.

Hi rachaelwalker ,

I am also looking for the same percentage but only calcuate the last 90 days based on date entered while ignoring any other filter visuals that may be applied.

Your requirement is to calculate data with a warranty effective date within 90 days right? Suppose today is 10/22/2024,90 days before the date is 7/24/2024.The filter condition is 'Project Warranty Start' >= 7/24/2024 , 'Date Entered' >= 7/24/2024.If I understand it incorrectly Please correct me.

Use the following DAX expression to create a measure

Measure = 
VAR _a = CALCULATE(DISTINCTCOUNT('Table'[Project Number]),'Table'[Date Entered] >= TODAY() - 90 && 'Table'[StartDate] >= TODAY() - 90 )
VAR _b = COUNTROWS(FILTER('Projects',[Project Warranty Start] >= TODAY() - 90))
RETURN DIVIDE(_a,_b)

 

Best Regards,
Wenbin Zhou

rachaelwalker's avatar
rachaelwalker
Resolver III
1 year ago

The warranty effective dates are between (Project Warranty Start Date) and (Project Warranty Date + 90 Days) so not 90 Days from today but from the Project Warranty Start. If a ticket is entered between between those dates, it goes against the project. There could be multiple tickets entered against a project but I dont want that to impact the %. Hopefully I am making sense

 

Anonymous I will plug these in and see how it looks against my dataset. Thank you!