Forum Discussion
Cardinality/Relationship Issue
- 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 trulynaveen ,
This can be accomplished without an active relationship. I loaded your data into PBI (big thank you for providing data, that really helps us helping you!) and created the following measures:
Budgeted Minutes = SUMX(FILTER(DateDup, DateDup[Date] <= TODAY()), [Budget Minutes])Actual Minutes =
SUMX(FILTER(JobsData, JobsData[NewJobClass] = SELECTEDVALUE(DateDup[DeptName])), [Total Minutes])Then I created a table visual and put in the column DateDup[DeptName] and the two measures, resulting in this:
Does this answer you question?
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
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:)This worked for me!