Hi,
Sorry if this is the wrong place to post this, but I'm tearing my hair out. I have a column in a table 'TPPY - PROD_Despatch_Items' called 'OTIF', which is just a "Yes" or "No" to dictate whether an order was delivered on-time and in-full.
I want to get a percentage of how many "Yes" there are, so I've used the below DAX formula in a Measure. This has worked in the past in other PBI reports I've created, but here when I use the measure on a visual it just shows a blank value.
I also tried creating a column with this formula instead of a measure and instead of showing a percentage in each row, all the "Yes" rows had a 1 and "No" rows are just blank.
I really don't know where I've gone wrong.. this uses the exact same logic that I've used in another PBI I made a while back.
Any advice would be appreciated, or if there's a more suitable place to get help with this please do point me in the right direction.