Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need help with DAX-New User

ello, I am a new user of Power BI. Could you please help me with the Problem. I want to find a count of New bidders who did not enter the auction other than Last Hour( LH).  The result should be matching with the column name NewBidders. 
OH-Other Hours
LH-Last Hours
AuctionIdLastHourBidderIDNEWBIDDERs
ALH11
ALH20
AOH20
BOH20
BLH31
COH40
CLH51
DLH60
DLH71
DLH81
DOH60
DOH60
    
 
 
 
 
 
 
 
 
Need Help
  • nandic's avatar
    nandic
    6 years ago

    Anonymous ,

     

    Here is screenshot of the formula:


    It works on my side, just make sure it is the same as on these screenshots.
    If it still displays error, please send screenshot as my first screenshot so that we can see what is causing the error.

    Cheers,
    Nemanja

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous - Question. If Bidder X entered last hour for auction A and not OH for auction A but entered OH for auction B, should they be flagged as a 1 for auction A and 0 for auction B or 1 for both or 0 for both?

  • nandic's avatar
    nandic
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

    Hi Anonymous ,

     

    Could you try this formula:

    New bidders =
    VAR newBidders =
        CALCULATETABLE (
            VALUES ( Sheet1[BidderID] ),
            FILTER ( Sheet1, Sheet1[LastHour] = "LH" )
        )
    VAR oldBidders =
        CALCULATETABLE (
            VALUES ( Sheet1[BidderID] ),
            FILTER ( Sheet1, Sheet1[LastHour] = "OH" )
        )
    VAR onlyNewBidders =  EXCEPT ( newBidders, oldBidders )

    RETURN
    CALCULATE ( DISTINCTCOUNT ( Sheet1[BidderID] ), onlyNewBidders )

     

    Cheers,

    Nemanja

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    nandic nandic I to used formula but giving me error "circular dependency was detected: Sheet1[Column]"
     
     
     
     
    • nandic's avatar
      nandic
      Icon for Resident Rockstar rankResident Rockstar
      6 years ago

      Anonymous ,

       

      Here is screenshot of the formula:


      It works on my side, just make sure it is the same as on these screenshots.
      If it still displays error, please send screenshot as my first screenshot so that we can see what is causing the error.

      Cheers,
      Nemanja