Forum Discussion
Measure/Dax for given Condition
I Have a table with columns as listed and need to find the condition as if the Median > Partner value--> Present the Median, else if the Avg > Partner value --> Present the Avg otherwise preset Max(a...
Please provide sample data in usable format (not as a picture - try adding as a table).
Hey Please Find the Sample data in Tabular Format-
VorgMpid Partner Presence Total Active Comp Part Pres Solution Part Pres Industry Solution Pub part Part Handling in sol Plat Handled Part Normalized score Cluster 1014637 2 3 5 0 1 4 2 0.423 0 1014638 1 0 1 3 0 7 4 1.233 0 1014640 0 3 2 8 0 0 0 0.231 1 1014642 3 2 2 5 6 0 1 0.455 1