Forum Discussion

KaroRoza's avatar
KaroRoza
Helper I
2 years ago
Solved

DAX help needed - context filter only for values in both categories

Hi,

 

Could you please help me with solving issue with DAX formula?

I created very simple dataset which I replicate my problem with main dataset ( sales data).

 

I would like to filter only for Groups which have sales in both Catogies ( there is "Category" column = Main or Discount). 

In the end, I am interested in table ( similar to the pivot table in Excel), but only for Groups which have sales in 'Main' and 'Discount'. I do not want to compare only 'Discounted" or 'Main' products, I would like to have a look only at both categories sales.

 

Many thanks,

Karolina

 

 

 

  • Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

     

1 Reply

  • Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.