I have created a measure T/F = IF([Total TaskTime Rate] = [Total Rate Check VS Invoice], "True","False"). When I take this measure into table visualization, I am only getting "False" as answer for all rows though condition meets. [TaskTime Rate] measure is created from calculated column "TaskTime Rate" and measure [Total Rate Check VS Invoice] is created from calculated column "Rate Check VS Invoice".
And now "Rate Check VS Invoice" column is created using 2 columns EPAM_TBV[Business Hours Rate], EPAM_TBV[DSS Adjustment] and 2 measures [Volume Discount],[Addl Premium Fee]. And "TaskTime Rate" column is created using 2 columns i.e, EPAM_TBV[Total Project costs] and EPAM_TBV[Project hours].
I want to know why I'm getting only false as answer. Is it because I have created columns using both measures and columns? Is it correct to create so?, and if there is any other error? Let me know.
