topic Re: DAX Question-I am trying to write a DAX Measure for Power BI Desk Top in DAX Commands and Tips

DAX Question-I am trying to write a DAX Measure for Power BI Desk Top

Mbryanton — Fri, 02 Feb 2024 14:26:39 GMT

I am still very new to DAX, but I have a table where I need to create a DAX measure to count the values from the Values column if the Origin Column equals 4 specific locations. And then another measure to count the values if the same origin column does not equal those first 4 locations.

Any suggestions are greatly appreciated

Re: DAX Question-I am trying to write a DAX Measure for Power BI Desk Top

Dangar332 — Fri, 02 Feb 2024 14:43:56 GMT

hi, Mbryanton

try below measure for specific 4 location

4specific location measure= calculate( count(tablename[value]), tablename[origin column] in {"location1","location2","location3","location4"} )

not equal those first 4 locations

4specific location measure= calculate( count(tablename[value]), not(tablename[origin column]) in {"location1","location2","location3","location4"} )

Re: DAX Question-I am trying to write a DAX Measure for Power BI Desk Top

Mbryanton — Fri, 02 Feb 2024 15:42:31 GMT

It doesnt seem to be adding up the values correctly when doing a check against the two measures. Could COUNT be the wrong function to apply? maybe it should be SUMX