Forum Discussion
Matrix columns
Thanks for your help AllisonKennedy
What's the code for Total vehicles dividido por Recuento de Dia?
Total vehicles dividido por Recuento de Día =DIVIDE(SUM('VEHICLE_OCCUPATION_AUDIT_VIEW'[Total vehicles]);COUNTA('Función invocada'[Día])Regarding your other questions, Ill restart the work following your advices and see if it works.Yesterday I kept trying other options but now I dont have the totals for each family nor the general total:
What's the code for Total vehicles dividido por Recuento de Dia?
Your data model ocnfuses me a bit still, it has a lot of double counting. We might be able to fix some of it with SUMX, or a few other tricks, but not sure yet.
The value table should be the only one with Units or Cost in it, ideal, and should have the monthly cost and number Units and date and vehicle code.
Then you can relate that to the Date table and also relate it to the Code table, and the quick measures would behave a bit better.
However, because you have both value table and item table, these are two 'fact' tables as we call them, and getting them to interact properly in DAX requires a lot of thought and understanding of the context of DAX.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
Thanks for your help AllisonKennedy
What's the code for Total vehicles dividido por Recuento de Dia?
