Forum Discussion

ani99's avatar
ani99
New Member
6 years ago
Solved

Matrix visualization show row count

Hello All, I have created a matrix visualization. I have multiple rows in matrix to make it look like a drill down report. I had a requirement to show the count at the end of the rows, then sub-ro...
Need Help
  • ibarrau's avatar
    ibarrau
    6 years ago

    It is a really crazy requirement to have this concatenated values. I was trying to explain that only measures can change dynamically. You need to build a measure with this values instead of columns if you want the filter to recalculate the values.

     

    Regards,

ibarrau's avatar
ibarrau
Super User
6 years ago

Hi, you can try two things. First adding any column of the table and make it a count in the visualization or create a measure like COUNTROWS ( Table ). That should be dynamic.

 

Regards,

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

  • ani99's avatar
    ani99
    New Member
    6 years ago

    ibarrau Thanks for your reply. But I am still bit unclear on what you have suggested as I am quite new in PBI.


    My calculation is below:


    Ad Source = CONCATENATE(Ads[AdName],CONCATENATE(CONCATENATE(" (",CALCULATE(COUNTROWS(Ads),ALLEXCEPT(Ads, Ads[AdName]))),")"))

    Can you please help me a little more by guiding if I need to tweat this query ?

    • ibarrau's avatar
      ibarrau
      Super User
      6 years ago

      It is a really crazy requirement to have this concatenated values. I was trying to explain that only measures can change dynamically. You need to build a measure with this values instead of columns if you want the filter to recalculate the values.

       

      Regards,