Forum Discussion
Visar
7 years agoFrequent Visitor
Function Filter with 2 arguments
Hello everyone,
I have a data table like this one :
I want to do a 3 lines chart to compare
- Sessions
- Session with a filter medium = organic
=>Organic Sessions = CALCULATE(SUM('MyDataSet'[Sessions]);FILTER('MyDataSet';'MyDataSet'[Medium]="organic"))
- Sessions with a filter medium = organic AND Page path level 1 = "/coloration"
I dont know how to write the last formula.
Could someone help me please ?
Thanks !!
Visar
Visar Please try this...
CALCULATE(SUM('MyDataSet'[Sessions]),FILTER('MyDataSet','MyDataSet'[Medium]="organic" && 'MyDataSet'[Page path level 1] = "/coloration"))
2 Replies
- PattemManoharCommunity Champion
Visar Please try this...
CALCULATE(SUM('MyDataSet'[Sessions]),FILTER('MyDataSet','MyDataSet'[Medium]="organic" && 'MyDataSet'[Page path level 1] = "/coloration"))- VisarFrequent Visitor
Awesome Thanks !!