Forum Discussion

unarsezer's avatar
unarsezer
Frequent Visitor
3 years ago
Solved

Filter With Another Measure

I want the user to select a special id with one slicer input. I have a table. This table has different columns including special_ids. One of these columns is the "league" column. I request that I use the league column of the special_id selected by the user as a filter for another measurement.

 

For example, the user has selected Leo Messi from the slicer input. In the table with Leo Messi, the league column says USA1. I want to use this "USA1" value as a filter for another metric.

 

Selected League = SELECTEDVALUE(final_biograpy_data[special_id])
 
When I add the above measurement to a Card image, I get the result I want. Whoever the user selects, the league of the selected special_id appears on the card. But...
 
row_number = CALCULATE(
    COUNTROWS(deneme),
    FILTER(
        ALLEXCEPT(deneme, deneme[attacking_labels]),
        deneme[league] = [Selected League] && deneme[template_position] = "CF"
    )
)
 
When I run the above measure, unfortunately, it covers all leagues in the dataset. However, the user has selected Leo Messi. His league was USA1. USA1 has a total of 250 special_ids, while the whole dataset has 10000 observations. Why is this filter not working?
 
I'm new to PowerBI. Thank you for your understanding.
 
Note: The common column in two different data sets is the special_id column. 
 
 

 

 

  • Manoj_Nair's avatar
    Manoj_Nair
    3 years ago

    unarsezer- Please check this out and let me know if this work.

    row_number = 
VAR SelectedLeague = [Selected League]
RETURN
    CALCULATE(
        COUNTROWS(deneme),
        FILTER(
            ALLEXCEPT(deneme, deneme[attacking_labels]),
            deneme[league] = SelectedLeague && deneme[template_position] = "CF"
        )
    )

    I've hypothetically established this DAX measure, but without much clarity regarding your datasets. If this doesn't serve your needs, I recommend you share a sample dataset. This will give me a more comprehensive understanding of your data structure, enabling me to devise a more suitable solution. Cheers

     

2 Replies

  • Manoj_Nair's avatar
    Manoj_Nair
    Solution Supplier
    3 years ago

    unarsezer- Please check this out and let me know if this work.

    row_number = 
VAR SelectedLeague = [Selected League]
RETURN
    CALCULATE(
        COUNTROWS(deneme),
        FILTER(
            ALLEXCEPT(deneme, deneme[attacking_labels]),
            deneme[league] = SelectedLeague && deneme[template_position] = "CF"
        )
    )

    I've hypothetically established this DAX measure, but without much clarity regarding your datasets. If this doesn't serve your needs, I recommend you share a sample dataset. This will give me a more comprehensive understanding of your data structure, enabling me to devise a more suitable solution. Cheers