Forum Discussion
Cumulative sum with multiple filters
My objective is to calculate the sum of total population for a city based on 2018 year, and three different wage distribution bins Under 30k =
CALCULATE(
SUM('Wage Distribution'[Total Po...
If ID Year is set to number, you need to remove the quotes from "2018" to be simply 2018
When you use the quotes, DAX assumes it to be text, so for numeric fields just simply state the number.
Hi Anonymous ,
As pointed out by AllisonKennedy , Remove quotes from the year "2018" .
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi Anonymous ,
Try one more option.
Go to Power Query and set the Data Type as text.
As of now it will be depicting 123ABC -> Change that to Text.
Regards,
Harsh Nathani