Forum Discussion

Krijgersss's avatar
Krijgersss
Icon for Helper II rankHelper II
1 year ago
Solved

Financial Reporting Matrix Profitbase NEED HELP

Hello i need some help with the visual "FInancial Rpeorting Matrix By Profit base" i want te make a tabel with 3 colums like the table below. i need some help with my total Colum and my % colum.  ...
Need Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    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
)

     

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

KrijgersssY ou can create a calculated column that will show the total value for each description. Use the following 

DAX
Total =
IF(
ISINSCOPE('YourTable'[Description]),
BLANK(),
SUM('YourTable'[value $])
)

 

You can create another calculated column to calculate the percentage of each value relative to the total. Use the following DAX formula:

DAX
% =
IF(
ISINSCOPE('YourTable'[Description]),
BLANK(),
DIVIDE(SUM('YourTable'[value $]), CALCULATE(SUM('YourTable'[value $]), ALL('YourTable')))
)

 

Add a matrix visual to your report and place the "Description" in the Rows, "value $" in the Values, and the newly created "Total" and "%" columns in the Values as well.

Krijgersss's avatar
Krijgersss
Icon for Helper II rankHelper II
1 year ago

this wont work for me because i have to use the Financial reporting matrix by profit base because my total row has to be made by hand just as in excel to "add a Row after"