An example of a U.S. classified document; page 13 of a United States National Security Agency report on the USS Liberty incident, partially declassified and released to the public in July 2003. The original overall classification of the page, Top Secret code word UMBRA, is shown at top and bottom.
The Data Analysis Expressions (DAX) language is a formula language that allows users to define custom calculations in calculated columns and measures. DAX includes some of the functions that are used in Excel formulas, and additional functions that are designed to work with relational data and perform dynamic aggregation.
Im pretty new to writing DAX, and am trying to do something that would be simple in excel, but I can't seem to create it in Power BI. I'm trying to create a custom measure that says: Calculate the Sum of Column X IF Column A = Renewal OR Column B = Needs Alignment. Very simple measure, but I can't seem to get the OR statement in there, and I can't use the filters in the Calculate function because once I put Column X = Renewal, it filters out all of the Column B = Needs Alignment.