Forum Discussion
Filter Text using DAX
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")
If you are returning a string, you would want to use something like MAXX or MINX instead of SUMX.
Hi Greg_Deckler ,
I have another table named Report for Sales where I have to do the same requirement as the Marksheet table. In this Report for Sales table, I have to filter each person's details from the Title column. You can see the below screenshot.
Here, In this above screenshot, I have taken a slicer filter for your understanding purpose. As per my requirement, I want to show each person details. For example, When I will select "KEVIN", it will display only the details of KEVIN only.
But I want to do this thing by using Measure not by using any Filter.
Also, I have used your Measure formula as you said, but it is not working for me. And one more thing I want to say is, I want to display the measure by using the Clustered bar chart like the above screenshot.
You can view my sample report by clicking this link: Sample Report
Please, Can you suggest me what I have to do?
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")how would you do multiple words? IE Kevin, Jerry, Anisha