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!!
Sub Total formatting in cross tabs not retained on Report Server
Hi, some sub total formating that i apply in Desktop (May 2022 RS version) on cross tab tables is not being retained after loading to the server (May 2022 Report Server). In particular if i set the table 'Style' to 'None' and then apply sub total formatting it's not being retained. (I am setting the initial format style to 'None' as i want to start with a transparent table). Example crosstab: How it looks on Desktop: How it looks after loading to Report Server: You can see that any formatting i apply to the Sub total columns is lost. i.e. any background colour reverts to nothing and any text colour reverts to black. Thanks,
