Forum Discussion
Solved
Cardinality/Relationship Issue
https://tacoteam-my.sharepoint.com/:x:/g/personal/njonnalagadda_tacometals_com/ES--F9WiuqRGkOrsmHxa8coBSTg-7CvMNwN77j9pyg9hTg?e=Jy7qXA Hello everyone, I'm trying to build a variance report o...
- Hi, change the measure to this:
Actual Minutes =
IF(HASONEVALUE(DateDup[DeptName]),
SUMX(FILTER(JobsData, JobsData[NewJobClass] = SELECTEDVALUE(DateDup[DeptName])), [Total Minutes]), SUM(JobsData[Total Minutes))
This was typed on phone so forgive any typos.
For your graph question, that is a whole new requirement, please open a separate topic for that question with all necessary information so my peers can have a look at that as well:)
Hi, change the measure to this:
Actual Minutes =
IF(HASONEVALUE(DateDup[DeptName]),
SUMX(FILTER(JobsData, JobsData[NewJobClass] = SELECTEDVALUE(DateDup[DeptName])), [Total Minutes]), SUM(JobsData[Total Minutes))
This was typed on phone so forgive any typos.
For your graph question, that is a whole new requirement, please open a separate topic for that question with all necessary information so my peers can have a look at that as well:)
Actual Minutes =
IF(HASONEVALUE(DateDup[DeptName]),
SUMX(FILTER(JobsData, JobsData[NewJobClass] = SELECTEDVALUE(DateDup[DeptName])), [Total Minutes]), SUM(JobsData[Total Minutes))
This was typed on phone so forgive any typos.
For your graph question, that is a whole new requirement, please open a separate topic for that question with all necessary information so my peers can have a look at that as well:)
This worked for me!