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...
  • 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

     

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

 

  • unarsezer's avatar
    unarsezer
    Frequent Visitor
    3 years ago

    It worked like a charm! Thanks a lot!