Forum Discussion
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 d...
bhanu_gautam
Super User
Super UserAnonymous ,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)
The values still dont show in the cell where I want them to. Maybe you can please explain the steps? bhanu_gautam