Forum Discussion

PreetiSahu321's avatar
PreetiSahu321
Helper I
6 years ago
Solved

Filter Text using DAX

Hello Power BI Community Members,   I have a requirement where I can use only the Power BI DAX. In Power BI Desktop, I have a table named as Marksheet. This table has below columns as: Title (By ...
power bi
POWER BI Dax rules
  • Anonymous's avatar
    Anonymous
    6 years ago
    KevinProjectedMTDSales = CALCULATE(SUM('Report for Sales'[Projected MTD Sales_]),'Report for Sales'[Title]="KEVIN")

KevinCurrentMonthBudget = CALCULATE(SUM('Report for Sales'[Current Month Budget]),'Report for Sales'[Title]="KEVIN")
Anonymous's avatar
Anonymous
Not applicable
6 years ago
KevinProjectedMTDSales = CALCULATE(SUM('Report for Sales'[Projected MTD Sales_]),'Report for Sales'[Title]="KEVIN")

KevinCurrentMonthBudget = CALCULATE(SUM('Report for Sales'[Current Month Budget]),'Report for Sales'[Title]="KEVIN")
KN_HEALT47's avatar
KN_HEALT47
Frequent Visitor
5 years ago

how would you do multiple words? IE Kevin, Jerry, Anisha