Forum Discussion
records missing in DAX formula using Dataverse
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.
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.
Apology there. See below. It is the same target table, just different filter value.d confirming I do have correct relationship in place.
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.
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!