topic Displaying two Fields data into same table. in DAX Commands and Tips

Displaying two Fields data into same table.

Shameem — Tue, 23 Apr 2024 10:16:00 GMT

We have a requirement where we have two Product fields. One is Product (single select), other field is 'Local Product(Multi select)'.

Product and local product are not associated in symantic model.

Requirment is to when one value of Product filed selected and some values in local product are selected both the selections should be displayed with thier respective volumes into the table .

Eg: Product : Car; Local Product : Bike , Bus

Result :

Product	Volume
Car	200
Bike	500
Bus	100

Re: Displaying two Fields data into same table.

tamerj1 — Tue, 23 Apr 2024 11:30:44 GMT

Hi Shameem
Please refer to attached sample file with the proposed solution

Re: Displaying two Fields data into same table.

Shameem — Tue, 23 Apr 2024 12:38:41 GMT

Hello tamerj1 , Thank you for reply, I have same values in both Product and local product field. And one is single select and other is multi select respectively, as in UI same screen contains few metrics which are depending on single select field and few metrics depend on both . Below is the case.

Re: Displaying two Fields data into same table.

tamerj1 — Tue, 23 Apr 2024 13:09:39 GMT

Shameem

Re: Displaying two Fields data into same table.

Shameem — Tue, 23 Apr 2024 14:08:31 GMT

Thank you for the solution.