Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
@Visar Please try this...
CALCULATE(SUM('MyDataSet'[Sessions]),FILTER('MyDataSet','MyDataSet'[Medium]="organic" && 'MyDataSet'[Page path level 1] = "/coloration"))
Proud to be a PBI Community Champion
@Visar Please try this...
CALCULATE(SUM('MyDataSet'[Sessions]),FILTER('MyDataSet','MyDataSet'[Medium]="organic" && 'MyDataSet'[Page path level 1] = "/coloration"))
Proud to be a PBI Community Champion
Awesome Thanks !!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |