Hi PowerBI Gurus,
Hope you all are keeping well.
I have a Measure which calculates Returns% = [No of Returns]/[No of Sales]. when I pull the month from calendar table and measure from another query and put it in a table it shows only the months with data and doesnt display other months. I know there is an option to Show Items With No data. But due to certain limitations I dnt want to use that option and instead want all the months to be displayed with 0% against the month with no data.
Any leads would be apprecaited. Thanks in advance for your time.