Forum Discussion
Helper ICalculating Percentages on a field that has multiple values
I realized that a simple solution was just to format the measure as a percentage. This fixed the issue with the formating but made my table massive in size adding several blank fields with really odd numbers for my total produced column. I have no idea where to go with this one, but here is a pic.
Number of Failure vs Total Produced = FORMAT(DIVIDE(AviationTable[Formula Count], max(GroupedbyUnitDescription[total produced]),"no result"), "percent")
Helper II found a way to get it to work. I created a copy of the AviationTable and grouped by the unit description and total produced. I was then able to relate the tables using the unit description. However this is not perfect I now have a resulting question. I imagine this will be easy to solve but I am new to DAX and Power BI. Currently the calculation shows in 0.00 format. I want to see it in 0.00000 at least if not a 0.000%.
Number of Failure vs Total Produced = CALCULATE(DIVIDE(AviationTable[Formula Count], max(GroupedbyUnitDescription[total produced]), "no result"))
This is the formula I am using currently.
This is the table and how it looks now. I see a lot of 0.00 which provides no value to me since I expect to see values that do not equal a full percent.
Helper II realized that a simple solution was just to format the measure as a percentage. This fixed the issue with the formating but made my table massive in size adding several blank fields with really odd numbers for my total produced column. I have no idea where to go with this one, but here is a pic.
Number of Failure vs Total Produced = FORMAT(DIVIDE(AviationTable[Formula Count], max(GroupedbyUnitDescription[total produced]),"no result"), "percent")
- mfminor
I was able to filter out all the weird results and not disturb the actual results. I am now satisfied with the results I have. I still think that my previous post with the weird "anomaly" that occurred could be addressed.