Forum Discussion
suvechha
Helper IV
Helper IVMdxscript (Model) Calculation error
Hi there, I am getting an error for the Measures : SDUserId = CALCULATE( VALUES(SDUser[USERID]), USERELATIONSHIP(WorkOrderStates[OWNERID], SDUser[USERID]) ) I have a...
suvechha , you need have some operation like , min , max , count , sum
SDUserId = CALCULATE(
Count(SDUser[USERID]),
USERELATIONSHIP(WorkOrderStates[OWNERID], SDUser[USERID])
)to get top 10, use topn or rank
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
v-easonf-msft
Community Support
Community SupportHi , suvechha
Take a try to use FIRSTNONBLANK(SDUser[USERID], 1) instead of SDUser[USERID].
Best Regards,
Community Support Team _ Eason