Measure as an input in a single cell

[Anonymous]

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 🙂 

[bhanu_gautam]

@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]

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