Forum Discussion

lyonslat's avatar
lyonslat
Frequent Visitor
6 years ago

Calculate with multiple criteria

Hi All,    First post, so apologies if it doesn't make a huge amount of sense, but I'm really hoping someone can help me.    Relatively new to DAX, but very familiar with Excel, so most of my log...
lyonslat's avatar
lyonslat
Frequent Visitor
6 years ago

Hi Pravin, 

 

Thanks for your input, it's much appreciated. 

 

Unfortunatley this didn't quite work the way I expected it to. 

 

The result I'm looking for is to show the number of transactions that contain both Food and Beer. The result that your suggestion put forward, gives me a number of the transactions that contain either food or beer and totals them up. 

 

Any suggestions?

 

Thanks, 

Ben 

lyonslat's avatar
lyonslat
Frequent Visitor
6 years ago

The best way I can describe this is if you imagine a venn diagram of transactions.

 

One side has food transactions, the other has beer, and in the middle you have the number of distinct transactions that contain both food and beer.