Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Help needed

Hi,    I have a Vehicle Data set where I have few OBD and Non OBD Fault Code data (Time they were active in seconds ). I want to divide sum of length of OBD Faults active (Sum of time when OBD Faul...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi! Anonymous 

     

    I used something like this 

    OBD_Lamp_Percentage = DIVIDE(CALCULATE(SUM( 'Active Faults'[Length of Active Fault Code]),FILTER('Active Faults','Active Faults'[Lamp. OBD Type ]="OBD")),SUM('Active Faults'[Master Data.Day_Length_Final]))
     
    and it seems to be performing the way how I wanted to the calculation to be. 
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi! Anonymous 

 

I used something like this 

OBD_Lamp_Percentage = DIVIDE(CALCULATE(SUM( 'Active Faults'[Length of Active Fault Code]),FILTER('Active Faults','Active Faults'[Lamp. OBD Type ]="OBD")),SUM('Active Faults'[Master Data.Day_Length_Final]))
 
and it seems to be performing the way how I wanted to the calculation to be. 
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

That's Nice!

 

If you think your issue is resolved you can mark it as a solution.

 

Thanks,

Tejaswi