Forum Discussion

Jacky_2022's avatar
Jacky_2022
New Member
3 years ago

Output tracking information from same day docu entry

Hi all,   I am an absolute rookie in Power BI and I don't know what to do with the following case.   My over all goal is to make a table visual that shows what type of tracking information record...
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , Jacky_2022 

According to your description, after you added filter expression in your oringinal dax formula ,the measure did not give any result now.I  found you use the selectedvalue() function for the newly added filter expression.Based on my experience, the selectedvalue() function can only output value when it's single seleted on the slicer or put in the table chart. So would you like to make sure this first?

For more information about selectedvalue() function , you can refer to :
SELECTEDVALUE function - DAX | Microsoft Learn

 

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

 

Jacky_2022's avatar
Jacky_2022
New Member
3 years ago

Hi Aniya,

thanks for your reply. Do you have any idea, which function I could use instead of selectedvalue, when I want to see the specific value of a cell as a result and not an aggregation function. I tried this:

 

TrackingInfo: Application =
var prospect_entrydate = CALCULATE(SELECTEDVALUE(Prospect_entry[CreatedAtDate]), Prospect_entry[new_ma_status_Status] = "assigned by KAM", FILTER(Prospect_entry,Prospect_entry[CreatedBy] = "D5D5" || Prospect_entry[CreatedBy] = "6FF5"))

var is_TrackingInfo = FILTER(employeeTracking, employeeTracking[CreatedAtDate] = Prospect_entry)

var result = CALCULATE(COUNT(Prospect_entry[ID_employee]), is_TrackingInfo,

FILTER(Prospect_entry,DATEDIFF([Creationdate],[Minimum Earliest date: CreatedAtDate per ID_employee],DAY)>=1))

return result
 
I got a result with this measure, but it seems to be not correct. Do you have any idea? I appreciate your help.