Forum Discussion

trulynaveen's avatar
trulynaveen
Frequent Visitor
6 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago
    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:)
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi trulynaveen ，

 

Try the following measures:

 

Budget = CALCULATE(SUM('Date-Dup'[Budget Minutes]),FILTER(ALLSELECTED('Date-Dup'),'Date-Dup'[Date]<= MIN('Date'[Date])))
Total Minute = CALCULATE(SUM('JobsData'[Total Minutes]),FILTER(ALLSELECTED('JobsData'),'JobsData'[EntryDate]<=MIN('Date'[Date])))

 

And you will see :

 

 

For the related .pbix file,pls click here.

 

 
Best Regards,
Kelly