Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Measure as an input in a single cell

Hello everyone, 

I am working on a document with two different excel files: GRN and RTB. 

Everyday the number of open entries (total rows) in excel sheet GRN is counted (filtered according to the date) and then fed in RTB as a single value in a cell pertaining to that day's date. Normally I enter the values manually in Excel but I was wondering whether there's a way to automize it using PowerBI? 

 

I have created a Measure: 

TotalGRN = COUNTROWS('GRN') 
 
but I cant seem to connect this with the RTB table, since I want the count in a Single cell. 

 

Is there a way PowerBI can do that itself? 

Thanks a lot for taking time and helping me 🙂 

 

Need Help

2 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    2 years ago

    Anonymous ,If you need to filter GRN by date, you can create a calculated column in the GRN table:
    IsToday = IF('GRN'[Date] = TODAY(), 1, 0)


    Then, modify your measure to count only today's rows:
    TotalGRN = CALCULATE(COUNTROWS('GRN'), 'GRN'[IsToday] = 1)


    Create Relationship:

    Go to Model view and create a relationship between the Date columns in GRN and RTB tables if they exist.

    Create a new measure in the RTB table:

    SingleCellValue =
    VAR CurrentDate = MAX('RTB'[Date])
    RETURN
    CALCULATE([TotalGRN], 'GRN'[Date] = CurrentDate)

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      The values still dont show in the cell where I want them to. Maybe you can please explain the steps? bhanu_gautam