Need help quick! Percent On Time measure not working with filters?
I have a whole page dedicated to exploring our products that have shipped late, meaning there is a page filter for [On Time Ship]="False". I also have a measure to calculate the % on time for each product. The formula is: % On Time = CALCULATE(DISTINCTCOUNT(CVD_OTD_FTMS_IV[Reference Number]),CVD_OTD_FTMS_IV[On Time Ship]=true(),REMOVEFILTERS(CVD_OTD_FTMS_IV[On Time Ship]))/CALCULATE(DISTINCTCOUNT(CVD_OTD_FTMS_IV[Reference Number]),REMOVEFILTERS(CVD_OTD_FTMS_IV[On Time Ship])) where [Reference Number] is the unique identifier for someone's ordered item. This measure isn't working the way I want it to and I am not sure why. The count of late items works as expected, but the total count (or denominator in my % on time measure) doesn't show what I expect unless I remove the page filter for [On Time Ship]="False". I don't know why this would be the case since I have a RemoveFilters command in the measure formula?? For example, the product below shows this with the page filter applied: and the same product without the page filter applied: The real total count is 277 for this product. Why is it only 55 when the page filter is applied?? I need help rather quickly, please and thank you!!
DAX Measure to Ignore Date Slicer
Good Day, I have a date slicer with a direct relationship with the table of unique values that I want a measure to ignore regardless of the active date slicer on the same visual page. I used the formula "ALL" to give me the total count of all unique ID in the table ignoring the slicer. Measure=CALCULATE (COUNT (Unique ID[ID), ALL('Calendar'[Date])) But... I want this measure to have a filter for a specific value which i used next as Measure = CALCULATE(COUNT(Unique ID[ID),FILTER(UniqueID,'Unique ID[Attempts ID]=FALSE()),ALL('Calendar'[Date])) Using this formula the date slicer is affecting the measure. Can someone please correct me if the measure i using is wrong.
