Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to Show Values for particular row Lets Suppose Monthly Percentage will sow only for Name Row

Dear Everyone ,

i am trying to show my Monthly Percentage to only Person name Row ..but same percentage is showing for below rows also ...i dont want that ....and Attendance days also i want to show only name row bit its showing for all rows please help me to solve this .

data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous , glad to help you.
    According to your description, you want to show only the results of the first level, but hide the results of the following levels, right?
    If I understand you correctly, I suggest you can try to use ISFILTERED() with IF () to manually control the display of the values in each level of the matrix.
    Here are my test results
    I created a test table:

    Created a measure and applied it to a matrix for presentation.

    Here is the DAX code:

    M_ = 
IF(
    ISFILTERED('Table'[member]),BLANK(),
    IF(
        ISFILTERED('Table'[group]),SUMX('Table',[value])
    ))

    By manually creating a metric, you can customise the output display for each row.

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,
    Carson Jian,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous , glad to help you.
    According to your description, you want to show only the results of the first level, but hide the results of the following levels, right?
    If I understand you correctly, I suggest you can try to use ISFILTERED() with IF () to manually control the display of the values in each level of the matrix.
    Here are my test results
    I created a test table:

    Created a measure and applied it to a matrix for presentation.

    Here is the DAX code:

    M_ = 
IF(
    ISFILTERED('Table'[member]),BLANK(),
    IF(
        ISFILTERED('Table'[group]),SUMX('Table',[value])
    ))

    By manually creating a metric, you can customise the output display for each row.

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,
    Carson Jian,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

       

      Thanks for quick answer , if you see my table i am expection 11, 20 and 55% values to only for Names ...not for below numbers (Numbers are weeks of month). i want to show only for that perticular person attended 11 days out of 20 days and that percentage is 55% .this is what i wan to show.  you did amazing work but its showing total of that value ..but i dont want that .i created this percentage and total days in seperate DAX ...i want to show if each person that values.