Forum Discussion
Find Variance based on selected values in Field Parameters
Good Afternoon Everyone, I have a good one here! I have a requirement to allow users the ability to create their own Custom Variances exactly as the image below (See image 1) 1. I hav...
Chanise89 Unfortunately yes. 😞
So I am still working through this & I just read your article on your dislike of CALCULATE.
Is there another way to write this statement w/o the use of CALCULATE:
Q122_Actuals = CALCULATE(
SUM('GL Data'[ACTUAL_AMOUNT]),
'GL Data'[VCH_QUARTER] = "Q1",
'GL Data'[N_YEAR] = "2022")
I think I have another approach, however I keep running into this error message "DAX comparison operations do not support comparing values of type true/false"