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:)
Thank you so much for the help. I just refreshed my data and wide opened to other departments by removing additional filters,now looks like your formula has worked. But I couldn't see the grand total under actual minutes.
Also, is there anyway we can put this on a Line Chart using CalendarAuto()?
Best,
Naveen
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!