Forum Discussion

atziovara's avatar
atziovara
Helper I
2 years ago
Solved

Filters based on IDs

I have a table called 'TableBI' which stores the answers of multiple companies to multiple questions. It looks like this:   Company ID Question Answer 1 Current Demand 0.3 1 Future De...
"DAX help"
"Need Help"
'Need help'
'Need help' 'DAX'
@NeedHelp
  • hackcrr's avatar
    hackcrr
    2 years ago

    Hi, atziovara 

    Thank you very much for your reply. I have re-edited my DAX expression below:

    AnswerFiltered =
VAR _table =
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[Question] = "Future Demand" && 'Table'[Answer] > 0.2 ),
        'Table'[Company ID]
    )
RETURN
    IF ( 'Table'[Company ID] IN _table, 'Table'[Answer] )

    The results are as follows:

     

    Best Regards,

    hackcrr

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

atziovara's avatar
atziovara
Helper I
2 years ago

hackcrr The data for the company whose ID = 1 are empty, because I would like to perform calculations for all the other companies that fit the criteria. I want to filter out companies based on the criteria related to Future Demand and then perform calculations with the answers of the remaining companies.

hackcrr's avatar
hackcrr
Memorable Member
2 years ago

Hi, atziovara 

Thank you very much for your reply. I have re-edited my DAX expression below:

AnswerFiltered =
VAR _table =
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[Question] = "Future Demand" && 'Table'[Answer] > 0.2 ),
        'Table'[Company ID]
    )
RETURN
    IF ( 'Table'[Company ID] IN _table, 'Table'[Answer] )

The results are as follows:

 

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.