Forum Discussion

cass_butchard's avatar
cass_butchard
Frequent Visitor
1 year ago

Creating a measure using multiple tables

Hi There,   I am new to this forum and require some assistance in creating a measure that displays the sum of a column which has been filtered by certain criteria.  However I have tried numerous wa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi cass_butchard ,

 

Can you please share the pbix or the data of defects and date in onedrive and share the link.

 

Can you paste the data model from the model view.

 

Cheers

 

CheenuSing

 

cass_butchard's avatar
cass_butchard
Frequent Visitor
1 year ago

Hi, Unfortunately I cannot provide access to the pbix due to our internal security requirements.. However I have included some print screens below of the Data Model - Please let me now if you require additional information

 

 

 

 

 

 

    • cass_butchard's avatar
      cass_butchard
      Frequent Visitor
      1 year ago

      Anonymous - Unfortunately I have re-created the above and it gives me the exact same figures as my original measure - Which is not the correct number is it does not align to the figures from the system.  The only thing I can consider is amending the date field used in the axis as it changes the figures when I use Date Raised or Completion Date but when I use a standard date field the numbers are the same as date raised. I really appreciate all your time and assistance in this matter. 

      The correct figure for this should be 996

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi cass_butchard ,

         

        It is very difficult to simulate the data. If possible just share the data with only columns to be used in the visuals and your date table, then only can provide a solution.

         

        Cheers

         

        CheenuSing