Forum Discussion

mark77's avatar
mark77
Helper I
4 years ago
Solved

TopN with others - WITHOUT additional table? (SSAS Tabular)

Hi. We use SSAS to prepare our datamodel for our powerbi RS reports.   I've been asked to add a number of "top n with others" visuals. There are some articles on this. And all seem to require an a...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    You are right, the standard matrix visual would not work for this as there are no rows to tag the measure against.  I am wondering if there are other matrix type visuals that can do that.

     

    I also didn't catch the fact that you are doing this on RS - that may further complicate things as custom visuals are more tricky there.

     

    See attached for a visual, erm, "solution" .

lbendlin's avatar
lbendlin
Super User
4 years ago

You are right, the standard matrix visual would not work for this as there are no rows to tag the measure against.  I am wondering if there are other matrix type visuals that can do that.

 

I also didn't catch the fact that you are doing this on RS - that may further complicate things as custom visuals are more tricky there.

 

See attached for a visual, erm, "solution" .