Display column total on measure value
Hi all, I am new to Power BI and can't seem to display the totals on my matrix for each column. Hoping someone can help! My matrix has (3) columns. The 1st is a quick measure, the 2nd is a custom measure that counts rows from my data source, and the 3rd is a custom calculation. My 1st column shows the totals, however the 2nd and 3rd do not. After doing some research, I believe the issue is due to custom forumlas in the 2nd and 3rd columns. But I've tried many different recommendations from other thread with 0 success. My formulas for the 2nd and 3rd columns are as follows: Count of Completed Training = COUNTROWS(FILTER('Training Tracking', SELECTEDVALUE('Training Tracking'[Training Topic - Levels]) = 'Training Tracking'[Training Topic - Levels] && SELECTEDVALUE('Current Employee Names'[Employee Name]) = 'Training Tracking'[Trainee])) % Complete Training Level = IF([Count of Completed Training]> 1, [Required Training]/1, if(NOT ISBLANK([Count of Completed Training]), [Count of Completed Training]/[Required Training])) Because the "Count of Completed Training" formula counts duplicates (intended). I had to create an IF statement so the "% Complete" didnt exceed 100%. I am not overly concered about the total on "Count of Completed Training", but the "% Complete" is key for the functionality of my report. Also, I've turned the column and row subtotals to "on" in the visulazations, but the apply settings to the per column level is set to "off" and wont allow me to change it (greyed out). Let me know if you require anymore info. Thanks in advance!!
Need formula help
Hello, I have 2 tables with absolutely nothing to create a relationship. But I need data from the first table into the second table, filtered on data from the second table. I have this formula but it is not returning correct value. Can someone please help? Adj = IF(ABC[Customer]="A",CALCULATE(FIRSTNONBLANK(Commodities[Adj],1),ALLEXCEPT(ABC,ABC[Model],ABC[Finish],ABC[PL Market]))) I've even tried using multiple filters and still same result. I do not want to use a measure or powerquery, he needs to be a new column. it is returning (0.218) for all rows. I am expecting Jan-Jun 0.0181 and Jul-Dec 0.0242 Thank you!
