Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Combination Field parameter - TopN - Legend not working

Hi,   see my test.pbix   https://www.dropbox.com/scl/fi/puhpfn9b0cx17hnmos2ty/test.pbix?rlkey=tlzbha299p9yybf38xrkk1aye&dl=0    In this pbix I combine a field parameter with a variable TopN. C...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    Anonymous update your measure to remove the filter from the channel column, as a good design there should be another dimension table for channels.

     

            SELECTEDVALUE(FP_Sales[Measures Fields]) = "'Sales'[Sum Sales Qty]",
        CALCULATE(
            RANKX(
                ALLSELECTED(Regions[Country]),
                [Sum Sales Qty],,DESC
            ), 
            REMOVEFILTERS(Sales[Channel] ) 
        )

     

     

     

parry2k's avatar
parry2k
Super User
2 years ago

Anonymous update your measure to remove the filter from the channel column, as a good design there should be another dimension table for channels.

 

        SELECTEDVALUE(FP_Sales[Measures Fields]) = "'Sales'[Sum Sales Qty]",
        CALCULATE(
            RANKX(
                ALLSELECTED(Regions[Country]),
                [Sum Sales Qty],,DESC
            ), 
            REMOVEFILTERS(Sales[Channel] ) 
        )

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi parry2k  

    I agree that Channel should be in a separate dimension. 
    Can you explain to me in a simple way why I should use REMOVEFILTERS here?
    If Channel was in a separate dimension, wouldn't it have occured then?
    By the way, thnx for helping me out !