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 |