Forum Discussion
Solved
records missing in DAX formula using Dataverse
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 ...
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 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!