Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Fault was active ) and Divide it by the total length (Sum of total length both OBD and Non OBD).
Something like this : Sum(Faut code length - OBD only)/ Sum of all fault code length
Fault Code length is the time in seconds the Fault Code is active
Solved! Go to Solution.
Hi! @Anonymous
I used something like this
Hi @sc_1991 ,
Will this work for you?
I created a measure like this to calculate the total sum by category.
measure = calculate(sum(Sheet12[Time in s]))
Then I used the same measure and calculated the % of Grand total like this.
Than in the table Visual I added the fields to show somethign like this:
Please let me know if this works.
Thanks,
Tejaswi
Hi! @Anonymous
I used something like this
Hi @sc_1991 ,
That's Nice!
If you think your issue is resolved you can mark it as a solution.
Thanks,
Tejaswi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |