Forum Discussion
Helper IIFinancial Reporting Matrix Profitbase NEED HELP
Hi Krijgersss
To achieve this, you need to use DAX measures that check whether the current row is a detail row or a total row, using the HASONEVALUE function. If it’s a detail row, the measure returns blank; if it’s a total row, the measure returns the sum or percentage. See below code references.
Total = IF( HASONEVALUE('Table'[Description]), BLANK(), SUM('Table'[value $]) )Percent = IF( HASONEVALUE('Table'[Description]), BLANK(), 30 // Replace 30 with your own calculation if needed )
Community SupportHi Krijgersss ,
Thanks for reaching out to Fabric Community Forum.
rohit1991 Thanks for your prompt response. In addition to that let me add more insights,
Following the DAX solution shared earlier by rohit1991 , I’ve implemented it on my side. Here is the expected output along with the attached PBIX file.
Hope this helps !!
Community SupportHi Krijgersss
Just a quick reminder your query regarding the custom Total and % columns in the "Financial Reporting Matrix by Profit Base" visual was already addressed earlier.
A working DAX solution along with a sample file was shared by the rohit1991 bhanu_gautam to help replicate and resolve the behavior you're targeting.
Please feel free to follow up if any additional clarification is needed.
- v-aatheeque
Hi Krijgersss
Just checking your question about custom Total and % columns in the "Financial Reporting Matrix by Profit Base" visual has already been addressed.
rohit1991 bhanu_gautam shared a working DAX solution and a sample file to help replicate and resolve the issue.
Let us know if you need any further clarification.- v-aatheeque
Hi Krijgersss
Following up on your question about creating the Total and % columns in the "Financial Reporting Matrix by Profit Base" visual. We had shared a sample PBIX file, expected output, and the DAX formulas earlier. Were you able to try them out, and did they resolve your issue?If we don’t hear back, we may close this thread in line with our community guidelines, but you’re always welcome to post a new query anytime.
Thank you for being part of the Microsoft Fabric Community!Looking forward for your response !