Forum Discussion

Dave6547's avatar
Dave6547
Regular Visitor
6 years ago
Solved

Value in visuals based on Max value in another dataset

Hello,   Im brand new to PowerBI.  I have a very large data model with many sources that collects data over time. (Some parameters are at different time intervals).   I would like the value in ea...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Dave6547 ,

     

    Please check the Pbix.

    There might be some differeces with your table, if you don't have any Confidential Information, better to share your pbix to us.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Dave6547 ,

 

Please refer to the following steps.

1# Create a measure as below.

Measure = CALCULATE(SELECTEDVALUE('Table'[Column1]),FILTER('Table','Table'[Column2]=MAX('Table'[Column2])))

2# Create a visual for dataset 1 and create a measure as below then add it to visual level flter.

Measure 2 = IF(SELECTEDVALUE('Table (2)'[Column1])=[Measure],1,BLANK())

 Result would be shown as below.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Dave6547's avatar
Dave6547
Regular Visitor
6 years ago

Hi Jay,

 

Thanks for the response.

 

I am still having a bit of trouble.

 

The first measure you described does get me to the time of day that the max occurs.

 

The second measure comes up as blank when I put it into a visual, and the filter dropdowns for measure 2 do not allow me to interact with them and set to 'is not blank'

 

 

 

This is what I have for the measures.

 

Test Measure 1 = CALCULATE(SELECTEDVALUE('multitrends-data-cooling_profil'[Date/Time]),FILTER('multitrends-data-cooling_profil','multitrends-data-cooling_profil'[AER Flowmeter kW]=MAX('multitrends-data-cooling_profil'[AER Flowmeter kW])))

 

Test Measure 2 = IF(SELECTEDVALUE('multitrends-data-Condenser_Circ'[Date/Time])=[Test Measure 1],1,blank())

 

Also,

I don't want to display all of the visuals as a table,  will this method work with guages as well?

 

Appreciate your help.

 

Cheers!

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Dave6547 ,

     

    Please check the Pbix.

    There might be some differeces with your table, if you don't have any Confidential Information, better to share your pbix to us.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.