Visuals are not showing incomplete data or no data at all

Power BI
1

Hi everyone,

I am facing an issue with a report that is not showing all the data on my table visual.
I have created a report that shows the expenditures in $$ based on deduction codes, and have created views to show how many people owe more than 4 week, or 3 weeks and less. The issue is that some deductions arent being listed and some users arent on the list at all.
-When I look at the data model, I see all the correct information on there
-The issues are mainly with Past Due Deductions and Past Due R&M columns in the visuals.

  • Some deductions are being calculated while others, for the same users, arent.

These are the Dax formulas I used to calculate the totals for Past Due RM and Past Due Deductions:

Other Deductions (No TN/Fuel/RM) =
CALCULATE(
SUM(‘Loan Deductions’[Amount]),‘Loan Deductions’[Ded. Code] in
{“OO-2290DED”,“OO-2290RTL”,“OO-AAIC”,“OO-AALEASE”,“OO-ACCIDEN”,“OO-ACCRUED”,“OO-ADMIN”,“OO-ADMSRV”,“OO-ADVANCE”,“OO-ATBFEE”,“OO-AUTOLIA”,“OO-BACKGRD”,“OO-BADDEBT”,“OO-BOBTAIL”,“OO-BONUS”,“OO-BPLATE”,“OO-BRAND”,“OO-C2671”,“OO-CARINS”,“OO-CARRFEE”,“OO-CARRLEA”,“OO-CHECK”,“OO-CHECK2”,“OO-CHECK3”,“OO-CLINK”,“OO-CORRECT”,“OO-D8362”,“OO-DATALOG”,“OO-DEBTINS”,“OO-DOC”,“OO-DRUG”,“OO-DRVR”,“OO-ECXINT”,“OO-EFPINT”,“OO-EFSADV”,“OO-EMREIMB”,“OO-EQUINOX”,“OO-ESCRINT”,“OO-ESCROW”,“OO-EXAM”,“OO-EXCINT”,“OO-EXPENSE”,“OO-FEDNTL”,“OO-FEETRAI”,“OO-FFOI1”,“OO-FFOI2”,“OO-FFPOI”,“OO-FUELTAX”,“OO-FXBONUS”,“OO-GARNISH”,“OO-GPS”,“OO-HEALTH”,“OO-HOLDING”,“OO-INSBOE”,“OO-INSGEN”,“OO-INSLIAB”,“OO-LEASE”,“OO-LEASFEE”,“OO-LLPROG”,“OO-LREBATE”,“OO-MACDEP”,“OO-MACRFEE”,“OO-MGTFEE”,“OO-MISC”,“OO-MISCCRG”,“OO-MISCFEE”,“OO-MISCINT”,“OO-MISCLOA”,“OO-MISCTRK”,“OO-MISREIM”,“OO-MVFUNDS”,“OO-NAVIGO”,“OO-OCCUP”,“OO-OWNEROP”,“OO-PANDIR”,“OO-PANINS”,“OO-PANLNTL”,“OO-PANNTL”,“OO-PANTINS”,“OO-PAYDOWN”,“OO-PENALTY”,“OO-PERMITS”,“OO-PHYSICA”,“OO-PLATE”,“OO-PLINTON”,“OO-POSTAGE”,“OO-PREPASS”,“OO-PRINON”,“OO-PROADV”,“OO-QCTEXT”,“OO-QUALCOM”,“OO-R&MFEE”,“OO-RECOVER”,“OO-REFERRA”,“OO-REPREIM”,“OO-SATELLI”,“OO-SDRTRAI”,“OO-SECKIT”,“OO-SECMISC”,“OO-SENSOR”,“OO-SETADFE”,“OO-SETADV”,“OO-SETDBB”,“OO-SETFUEL”,“OO-SETIFEE”,“OO-SETIFTA”,“OO-SETMAIN”,“OO-SETNTL”,“OO-SETOIC”,“OO-SETOMNI”,“OO-SETPD”,“OO-SETPFEE”,“OO-SETPHYD”,“OO-SETPINC”,“OO-SETPPAS”,“OO-SETPYMT”,“OO-SETRENT”,“OO-SETROAD”,“OO-SETSEMI”,“OO-SETTFLO”,“OO-SETTINS”,“OO-SETTLE”,“OO-SETTOLL”,“OO-STFEE”,“OO-STARTUP”,“OO-TAXIPAS”,“OO-TOLL”,“OO-TRAILER”,“OO-TRAVEL”,“OO-TRIPPAK”,“OO-TRIPSHE”,“OO-TRKEXP”,“OO-TRUECHO”,“OO-TTRANSP”,“OO-TTSCARG”,“OO-TTSNTL”,“OO-TTSTPD”,“OO-TVCLEGL”,“OO-USPS”,“OO-USTREAS”,“OO-WHTDOVE”,“OO-WIRE”,“OO-WORKCOM”,“OO-WRECK”,“OO-WRITEOF”,“OO-WRITOFF”,“OO-XPODBB”})

Total R&M =
CALCULATE(
SUM(‘Loan Deductions’[Amount]),‘Loan Deductions’[Ded. Code] in {“OO-R&M”})

This is the formula I use to show the Deductions totals in the visual:

Past Due Deductions =
CALCULATE([Other Deductions (No TN/Fuel/RM)],FILTER(‘Loan Deductions’,‘Loan Deductions’[Bill Date]<TODAY()))

An example of an error is that I do not see ID C2008 listed anywhere however they have expenses dated more than 3 weeks back

image
image707×696 52.7 KB

image
image1409×583 15.5 KB

These are the ID that should be on one of these visuals and I’m missing most of them.

image
image104×612 3.39 KB

Are these Dax formulas incorrect and causing this issue? Or maybe its something else that I missed?

I’ve been fighting with this for the past 10 days and I appreciate the help.
Deductions Test.pbix (2.7 MB)

2

Hi @Tali_USA ,

Quick check for ID C2008 - there are 2 data issues because it is not displayed in the table :

  • Last week PD (for that example is blank and you have filter visual on this is not 0)

  • Week Ending - filter - there is no data for that example for selected
    11/26/2022

You have only:

image

3

Thanks for pointing this out @mspanic
I’ll have to take a closer look at my filters since they seem to be throwing off the entire report.

1 Like
4

Hello @Tali_USA

Did the response above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need? If it did, please mark the solution that helped you.

Thank you

5

Hello @Tali_USA ,

Due to the length by which this post has been active, we are tagging it as Solved.

Thanks to the contributors of this post. @mspanic

For further questions related to this post, please make a new thread. Please feel free to reopen this thread if anyone would like to answer the pending inquiry above.

Thank you