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
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