Forum Discussion
TopN with others - WITHOUT additional table? (SSAS Tabular)
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" .
You need to create the additional tables but you don't need to materialize them. Instead you can use table variables inside the measures.
Measure = if(RANKX(ALLSELECTED(Variety[VarietyName]),[TurnOver])<11,SELECTEDVALUE(Variety[VarietyName]),"Other")
Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good).
Thank you for this first block, but the sollution is not yet complete.
I now indeed have a list of 10 VarietyNames and an other field. But cannot create the desired results.
When using expression [TurnOver] and just the [NewVarietyTop10] dimension, no data is displayed. Only a total summary line with no description is deplsyaed.
When adding the origional VarietyName, then all varieties are shown. (And the others also become visble in individual rows).
I'm asuming something needs to be done with the table to make it all work? What is the final step?
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.
hi,
I've prepared a sanitized dataset for you with just the case.
please follow this link
ZIP: https://drive.google.com/file/d/1awfmZQLftIELkMLqOg3h9f-WJj6cmlfu/view?usp=sharing
PBIX : https://drive.google.com/file/d/1tx9YfsNV7mgVACR9Hry51E5vh4d9BPNB/view?usp=sharing
I've included the desired result example as a picture, in the file as well.
Thanks again.
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" .