How to create relationship between calculated group and field parameter dataset

[awasthi1984]

Hi Team,

I have a calculated group with 4 calculation items and I also have a field parameter dataset in which we have one column that contains same name as calculatiopn items, I want to create a relationship between the same so that when we use calculated group in a slicer the field parameter values gets filered.

Thanks

[danextian]

Hi @awasthi1984 

Field Parameters from measures are essentially still measures so if they're added to a calculation group, the logic in the calculation group should still be applied to those measures assuming that the calculations items do not explicitly specify a measure but just use SELECTEDMEASURE(). Other than this, I can't think of anything else. There's just not enough data to provide an insight. Please refer to this post on how to get your question answered quickly: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447... 

[awasthi1984]

Hi @danextian 

We have a field parameter in which we have a levels for dimension attributes and a static attribute user type that contains values like below
Owner
Manager
Employee
We have a calculation group called as User Type and 3 calculation items for Owner, Manager and Employee and in each calcuation item we activate inactive relationship based on user type selection

Example when we are selecting user type as Owner or Manager or Employees we want to filter field parameter dataset created above so that it displays only those values

[Anonymous]

Hi @awasthi1984 

Thanks for the reply from danextian .

awasthi1984, if your problem is not solved yet, please provide some example data and expected result based on the example data so that we can better help you. How to provide sample data in the Power BI Forum - Microsoft Fabric Community  Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu