Forum Discussion

BarneyR's avatar
BarneyR
Frequent Visitor
5 years ago
Solved

Issue with reversing a percentage

Hello,   I am having a really frustrating issue with some of my data.   I have a measure which looks like this: Missing Data = IF([total_percentage] < 1, 1 -[total_percentage],0)   [total_per...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi BarneyR 

    From your figure 2 ,I think the result you want for Missing Data is the sum of three percentages, 'Table'[Output%] , 'Table'[Downtime%] , 'Table'[Reject%]

     

    Calculated column

    Missing Data = IF('Table'[Output%]+'Table'[Downtime%]+'Table'[Reject%]<1,'Table'[Output%]+'Table'[Downtime%]+'Table'[Reject%],0)

     

    If the sum of 3 percentages <1,the return value is 0 .Otherwise ,it will return the sum of 3 percentages .

    The effect is as shown:

    Best Regards

    Community Support Team _ Ailsa Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey BarneyR ,

 

yes, I had the issues with HTML in past also. It's very annoying.

Can you provide the file? It would make it a lot easier to help you.

 

Best regards

Denis

BarneyR's avatar
BarneyR
Frequent Visitor
5 years ago

Hi selimovd 

 

I will have to create a new file with test data as this currently links to SQL. But if I replicate the data inside Power BI I should be able to send you it. I will reply again once I have recreated it.