Trying to use Table Visual row values selected to create measures

[iAm3G]

Hi all,

I'm trying to identify the date value of a specific row selected within my table visual and use it to modify an existing measure by replacing the Today() part with that date from the row.

So for the example below I would need to identify that the date value is "2017-07-22" and use it in the measure:

SalesPerDate = CALCULATE(RealTimeData[Total Sales], DATEVALUE(RealTimeData[Date]) = TODAY()) 

PLEASE NOTE:

This is a streaming dataset and Calculated Columns / Editing Queries etc are not allowed. It has to be a measure to obtain that value and then use it in another measure.

Thanks for any assistance.

[Eric_Zhang · Accepted solution]

@iAm3G wrote:

Hi all,

I'm trying to identify the date value of a specific row selected within my table visual and use it to modify an existing measure by replacing the Today() part with that date from the row.

So for the example below I would need to identify that the date value is "2017-07-22" and use it in the measure:

SalesPerDate = CALCULATE(RealTimeData[Total Sales], DATEVALUE(RealTimeData[Date]) = TODAY()) 

PLEASE NOTE:

This is a streaming dataset and Calculated Columns / Editing Queries etc are not allowed. It has to be a measure to obtain that value and then use it in another measure.

Thanks for any assistance.

@iAm3G

If I understand your request correctly, you just need to remove the filter. The SalesPerDate would vary according to your slicer

SalesPerDate = CALCULATE(RealTimeData[Total Sales]) 

What is your another measure, the first measure would change according to the context of the another measure. 

By the way, is the RealTimeData[Date] a text column?

[iAm3G]

Hi there and sorry for the late reply. I'm new to Power BI and just started delving into measures etc...
Yes RealTimeData[date] is text because using date shows the date in a format not suitable for our international company and as I'm using a streaming dataset i cant do anything about that. Or at least I tried and couldn't.