Forum Discussion
sivarajan21
Post Prodigy
Post Prodigyfind max and min value from same column obtained from dynamic slicer selection and find difference
Dear all, I need to create a dax for dynamically selecting sites from the slicer and find the difference from max & min selected. For example, in above screenshot, I have selected 3 sites,...
Here is a sample of the pseudo code:
performance measure = divide(maxx(table,units)-minx(table,units),maxx(allselected(table),units)-minx(allselected(table),units))
you can refine that with SUMMARIZE(ALLSELECTED()) etc. Really depends on how you want to interpret it.
performance measure = var mmax = CALCULATE(max(DataProfile[Units]),allselected(Contacts[Name])) var mmin = CALCULATE(min(DataProfile[Units]),allselected(Contacts[Name])) return mmax-mmin
lbendlin
Super User
Super UserPlease check the link, it requires authentication.
sivarajan21Post Prodigy
Post ProdigyHi,
Apologise, i am sharing my one drive, can you please try this link
Profile Explorer (1) - Copy.pbix
if not, please let me know your email id or a link to a location where i can save this
Thanks