Forum Discussion

JMS1985's avatar
JMS1985
Frequent Visitor
6 years ago
Solved

Matrix columns

Hello,   Im new to power bi so my question might be simple despite I´ve been searching for a way to solve it and I can´t find the right way to get a solution to my problem.   I have a table with ...
Need Help
  • JMS1985's avatar
    JMS1985
    6 years ago

    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:
     
JMS1985's avatar
JMS1985
Frequent Visitor
6 years ago

Hello Allison, thanks for your reply and sorry for the little info I have provided.

 

These are the tables I have:

 

Date table. All dates between 2018 and 2021.

Value table. Where each vehicle has a code and each code has a unique value per month.

Item table. Where I have the number of vehicles with their code and the number of units per day.

Code table. where I have codes and families. I group vehicles into codes and codes into families.

 

The first column (sorry I cant display this info) shows Families and Codes.

The second column (Total vehicles dividido por Recuento de Dia) is the quick measure where I SUM all vehicles and divide them by the number of days selected on the date selector.

The third column is where I want to get the cost... In light grey Im able to get the cost for each code, but it doesnt SUM up right in the family total nor the general total.

 

thanks

 

Icey's avatar
Icey
Community Support
6 years ago

Hi JMS1985 ,

 

It is suggested to create a dummy .pbix file using dummy sample data for test. Please keep the structure of sample data same as your real data. You can upload your file to OneDrive for Business and then paste the link here.

 

 

Best Regards,

Icey