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,

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,