Adding a column with a MEASURE that states whether there are 1, 2 or more instances of a value
Hi all, I have the following matrix that get generated from 2 columns from 2 different tables. They are generated from a cube and I do not have access to change anything or add calculated columns. So the solution I am seeking HAS to be through a measure, if possible? So the goal is to add a third column that is based on a measure. The third column should indicate either: - If there is only 1 value of "Besøgsnummer" (the first column) = "Single" - If there is exactly 2 of the same value = "Double" - More than 2 of the same value = "3 or more" Hope it makes sense? So basically the first 2 rows of the screenshot needs to ha the third column saying "Double".
Getting Values by MAXIMUM Alphabatic Letter for Distinct Records
Hi All, Good day..! May I ask how can I get the values for "For Resubmit" Column by below conditions My Data Table as below 1. Consider only Latest Revision (Lastest Alphbatical Letter) for each RFA No. 2. If Engineer Response of those records are "Data Incomplete" or "Rejected" then need to count as 1 in "For Resubmit" Column As per above table I can get values for these records only> Noted: I have used below DAX Function to get Maximum Revision number = UNICHAR(MAXX(DISTINCT('RFA'[Rfa No]),MAX(UNICODE('RFA'[Revision]))) I need to find how can I apply Specific Values in "Engineer response" column to find "Resubmit" Values Thanks in Advance Rifdhy
