Forum Discussion
redhol
9 years agoFrequent Visitor
Creating a Measure based on set criteria
Hi All, I have just discover PowerBI and have already got a lot out of it for little effort, however I have now hit a stumbling block. I am trying to calculate ATV using our total sales colum...
- 9 years ago
MyMeasure = CALCULATE(SUM(Table[Sales]),Table[Category]="Bracelet" || Table[Category]="Rings")
Greg_Deckler
9 years agoCommunity Champion
MyMeasure = CALCULATE(SUM(Table[Sales]),Table[Category]="Bracelet" || Table[Category]="Rings")