Forum Discussion

BigBadBob's avatar
BigBadBob
Icon for Helper I rankHelper I
6 years ago
Solved

Dax Measure

Hi,   I know im being stupid but this is driving me crazy.    Based on the below data i would like to retrieve all lines where one of the lines has "Flag" = 1. I have included what the results sh...
DAX
  • AlB's avatar
    AlB
    6 years ago

    Hi BigBadBob 

    Create a calculated column that will say whether the row is to be shown:

    ShowLine = 
VAR res_ = CALCULATE(SUM(Table1[Flag]);ALLEXCEPT(Table1;Table1[ID]))
RETURN
IF ( res_ > 0; "YES"; "NO")

    Then place all the fields you want to show in a  Table visual and filter for ShowLine = "YES"

    It can also be done with a measure for the filtering, instead of a calculated column

    Please mark the question solved when done and consider giving kudos if posts are helpful.

     Cheers 

     

     

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi BigBadBob ,

     

    Please share sample data for both the tables and the relationship between them.

     

     

    Regards,

    Harsh Nathani

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
6 years ago

Hi BigBadBob 

Create a calculated column that will say whether the row is to be shown:

ShowLine = 
VAR res_ = CALCULATE(SUM(Table1[Flag]);ALLEXCEPT(Table1;Table1[ID]))
RETURN
IF ( res_ > 0; "YES"; "NO")

Then place all the fields you want to show in a  Table visual and filter for ShowLine = "YES"

It can also be done with a measure for the filtering, instead of a calculated column

Please mark the question solved when done and consider giving kudos if posts are helpful.

 Cheers 

 

 

 

  • BigBadBob's avatar
    BigBadBob
    Icon for Helper I rankHelper I
    6 years ago

    Hi - Massive thanks. The flag number is in another table. I tried using the below as a measure and it has not filtered it correctly. Sorry for not mentioning the second table in the original post

     

    Includes Cancelled =
    Var res_=
    CALCULATE(SUM(Policy[flag Number]),
    ALLEXCEPT(Transactions,Transactions[User ID]))

    RETURN
    IF(res_>=1,"Y","N")
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi BigBadBob ,

       

      Please share sample data for both the tables and the relationship between them.

       

       

      Regards,

      Harsh Nathani

      • BigBadBob's avatar
        BigBadBob
        Icon for Helper I rankHelper I
        6 years ago

        Hi,

         

        I constructed a basic model using the criteria we discussed on two tables and it worked. I cant see why it does not work in my first model but i am unable to share it. Thanks in advance and Kudos coming your way 😉