Forum Discussion
DAX COUNTX giving wrong results
Hi, I am trying to get my code to count the number of dates that have a rank or 5 or anything below 5. I tried to do this with the code below but it doesn't seem to work, could any one help please? ...
LivioLanzo
Solution Sage
Solution SageHi Anonymous
can you post the raw data?
Sure, here are some images of the tables i used
- LivioLanzo
Hi Anonymous,
sorry but I can't work with a snapshot. Are you able to post data which can be copy/pasted?
Sorry i think this may help more;
https://filebin.net/qlgusdv2f3w0pfm4
you can access the pbix file i am working on there and the file i am using too.
- Ashish_Mathur
Super User
Hi,
If you want to add up the values form the Data Table appearing against the bottom 5 ranking Year/Month, then try this measure
=Measure = SUMX(FILTER(SUMMARIZE(VALUES('Date Table'[Year and Month]),[Year and Month],"ABCD",[Rank],"EFGH",SUM(Data[Value])),[ABCD]<=5),[EFGH])
The answer is 308K
Hope this helps.
