Forum Discussion

Usix's avatar
Usix
Frequent Visitor
9 months ago
Solved

Removefilters, all, keepfilters behavior

Hi all, I have 2 tables  > Employees withs 2023 & 2024 salaries > a sample of employees ID on which I want to filter my visual   Both have an active relationship on employee ID   The visual I w...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    9 months ago

    Usix , All or remove filter should be used on a column in this case like 
    Same job family = CALCULATE(
    [Evolution],
    ALL('2023 2024'[Job Family])
    ))

    KEEPFILTERS- Prevents CALCULATE from expanding the filter to ALL Job Families- refer -https://www.sqlbi.com/articles/using-keepfilters-in-dax/


    for removing blank try 

    Same job family =
IF(
    ISBLANK(SELECTEDVALUE('emp filters'[ID])),
    BLANK(),
    CALCULATE(
        [Evolution],
        ALL('2023 2024'),
        KEEPFILTERS(VALUES('2023 2024'[Job Family]))
    )
)

     

v-sgandrathi's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
9 months ago

Hi Usix,

 

Thank you rohit1991 and amitchandak  for your prompt response to the query.

Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.