Incorrect result when using multiple similar measures with TREATAS and variables in the same visual.
When two measures that have a very similar looking but different calculation both use TREATAS with a variable as the first TREATAS parameter and are used in the same visual the output of one of the measures will incorrectly be a duplicate of the output of the other measure. This looks like an incorrectly applied DAX fusion optimization, which measure output gets duplicated seem to depend on which measure you add to the visual first. This is what the output should look like: Here is the incorrect output: Here is the DAX code of the two measures: Here is the data from the simple 2 table data model used to demonstrate the problem. I can provide a PBIX file that demonstrates the problem if needed.
Cannot hide two dynamic reference lines on same chart
If you have two dynamic reference lines on the same chart if you use a multi-select field parameter then you can uncheck to hide one reference line, but unchecking the second one causes the value to be set to 0 and not blank and it will still show on the chart. LOD reference line = VAR _RawSignalSelected = IF(SELECTEDVALUE('Indicator parameter'[Indicators])="'Measures Table'[Raw 7-day moving average]",TRUE(),FALSE()) VAR _SelectedRefLine = IF("'Limits of quantification and detection by disease'[Limit of detection (LOD)]" IN ALLSELECTED('Reference lines'[Reference lines Fields]) && ISFILTERED(('Reference lines'[Reference lines Fields])) = TRUE(),TRUE(),FALSE()) VAR _LOD = CALCULATE(MAX('Limits of quantification and detection by disease'[Limit of detection (LOD)])) RETURN IF(_RawSignalSelected && _SelectedRefLine,_LOD,BLANK()) LOQ reference line = VAR _RawSignalSelected = IF(SELECTEDVALUE('Indicator parameter'[Indicators])="'Measures Table'[Raw 7-day moving average]",TRUE(),FALSE()) VAR _SelectedRefLine = IF("'Limits of quantification and detection by disease'[Limit of quantification (LOQ)]" IN ALLSELECTED('Reference lines'[Reference lines Fields]) && ISFILTERED(('Reference lines'[Reference lines Fields])) = TRUE(),TRUE(),FALSE()) VAR _LOQ = CALCULATE(MAX('Limits of quantification and detection by disease'[Limit of quantification (LOQ)])) RETURN IF(_RawSignalSelected && _SelectedRefLine,_LOQ,BLANK())
Why doesn't REMOVEFILTERS work?
I have a simple formula that calculates the incident count per month, which is then broken down by our defined week of the month (all months have W1, W2, W3, & W4). Works great. Avg Count per month = 'Incident Measures'[_Inc Count] / [_Count of Months] The problem is I need this to calculate the counts while ignoring the date slicer on the page. I've tried using REMOVEFILTERS and ALL and nothing has worked: Avg Count per month - All months = CALCULATE('Incident Measures'[_Inc Count] / [_Count of Months], REMOVEFILTERS('DATE Table'[Year Month Name])) where "Year Month Name" is the column from the related date table that is the date slicer. I have been fighting this for 3 days and am no closer to a solution. Note: I cannot use Edit Interactions because the data is actually going into a cluster chart with other data that does need to be affected by the slicer.
