Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
iAm3G
Frequent Visitor

Trying to use Table Visual row values selected to create measures

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()) 


Clipboard01.jpg

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.

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft Employee
Microsoft Employee

@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()) 


Clipboard01.jpg

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?

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft Employee
Microsoft Employee

@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()) 


Clipboard01.jpg

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?

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.