Missing values in cumulative dax
Hello, I am trying to get a cumulative total which as you can see below it works, except in period 05 and 09, the totals should be 68 for period 05 and 108 for period 09. Since there were no values found for that period it gives you a zero. Can you please assist. Measure 2 = var startyear = DATE(2022,10,01) var enddate = MAX(Table1[Date Entered])-365 return IF(CALCULATE(COUNTA('Table1'[ID]),DATESBETWEEN('Calendar'[Date],startyear,enddate))=BLANK() ,0, CALCULATE(COUNTA('Table1'[ID]),DATESBETWEEN('Calendar'[Date],startyear,enddate)))
ADD NEW COLUMN with DAX throwing error
I have created a PBIX File on desktop with multiple tables. Out of those I have created an active relationship between 2 tables, Table A & Table B. Relationship between A&B is Many to One (Both) cardinality Now I added a NEW COLUMN in Table A and entered a DAX Formula which comprises of multiple conditions (refer formula below) using Columns from both Tables A&B. The same formula worked in another PBIX File with a different data set. However, despite both tables having an active relationship, the DAX formula is not suggesting Table B or any of it's Columns, so despite my formula being correct the result is an error with incomprehensible errors. Please help. Please Note- -Relationship Active -All Columns in Text Format -No data related errors upon refresh -Tables refreshed both in Transform, front end as well in the Relationship Model -Checked for duplications, blanks, etc. No data discrepancies -DAX Formula is New Column = MAXX(FILTER( 'TABLE A','TABLE A'[Date]>='TABLE B'[Migration Date]&& 'TABLE A'[Date]<='TABLE B'[Exit Date]&& 'TABLE A'[Unique Code]='TABLE B'[Unique Code]&& 'TABLE A'[Cluster Code]='TABLE B'[Cluster Code]), 'TABLE B'[Name])
Counting the values of a calculated measure
Hello everyone, I am creating a report that audits different columns and if the value is accurate, it comes back as Good, and if it isn't, it comes back as Fix. I then did a new measure that looked at those different columns, and if any of them said Fix, it returns value of Action Opp, and if all of them say Good, it returns a value of Good. My next step is to create a chart that shows the total count of Action Opp values and total of Good values. I've tried multiple ways of doing this an nothing is working. Any ideas of how I can count the total of each value?
