Forum Discussion

iAm3G's avatar
iAm3G
Frequent Visitor
9 years ago
Solved

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


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.

Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago
    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?

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago
    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's avatar
      iAm3G
      Frequent Visitor
      9 years ago
      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.