Forum Discussion

tiago's avatar
tiago
Icon for Helper I rankHelper I
9 years ago
Solved

[HELP] How to create my first DAX

Hi there, I work for a retail company and I a newbie on POWER BI. I have good knowledge in Excel and I am starting to learn POWERBI DAX. I am trying to do simple things to see If I can start to unde...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    In general:

     

    Measure = CALCULATE(COUNT(Table[Column]),FILTER(Table,[DISCOUNT] > 0))
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Try putting the table name in front of the second column. You'll definitely need to have all of the tables related to one another. Posting some sample/mock data would be very beneficial to posting a solution that would definitely work. You can also look into RELATED and RELATEDTABLE functions. For example, you could do things like:

     

    Measure = CALCULATE(COUNT(Table[Column]),FILTER(Table[DISCOUNT] > 0), FILTER(RELATEDTABLE(Table2), [Item_Sold] > 0))
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Try putting the table name in front of the second column. You'll definitely need to have all of the tables related to one another. Posting some sample/mock data would be very beneficial to posting a solution that would definitely work. You can also look into RELATED and RELATEDTABLE functions. For example, you could do things like:

 

Measure = CALCULATE(COUNT(Table[Column]),FILTER(Table[DISCOUNT] > 0), FILTER(RELATEDTABLE(Table2), [Item_Sold] > 0))
tiago's avatar
tiago
Icon for Helper I rankHelper I
9 years ago

Smoupre,

 

Thank you for the reply, definitely will study DAX, but your help was a great start to understand the language. Apparently you last suggestion worked.

 

Regards,

Tiago