records missing in DAX formula using Dataverse

[BruceAnderson20]

I have a strange issue.

I have a DAX measure that is not including many records.  I can see the records in design in Desktop when I add them in a table, but not in Dax.  In the below example I have 3 records that should be included, but only one is in Desktop and Service.  I checked the data types as I know Power BI doesn't like the Currency format from the dataverse, but they are decimal.  Any thoughts would be much appreciated.

[MFelix]

Hi @BruceAnderson20 ,

You are showing the Service Fee Measure however you are poiting to the Consumable values.

Can you share the formula for consumable please. 

[BruceAnderson20]

Apology there. See below. It is the same target table, just different filter value.d confirming I do have correct relationship in place.

[MFelix · Accepted solution]

Hi @BruceAnderson20 ,

You are returning the firstnonblank value that is why you are getting the 55, to get addtional data you need to add more details to your visualization, if you are using the Document N.º has your only detail you get the first value that you have in the datasource.

[BruceAnderson20]

Thank you!  I changed it to a SUM and now it is working.  The FIRSTNONBLANK put there by someone else, I was not familiar with it.  But the hint is in the name!