Forum Discussion
Count repeated
Good afternoon, I have a table with DATE, MONTH, NO CONTAINER (alphanumeric). I need to calculate the total containers per month. According to the text, January has 10 records and I need the answer ...
Hi Anonymous,
When you make a measure the calculations for total are make based on context so when you are in the totals you are calculating the distinct count of the full data set for january so if NO CONTAINER has only 3 values the total will return 3 you need to make this measure:
Total Containers = IF ( HASONEFILTER ( Table[Cliente] ); DISTINCTCOUNT ( Table[NO CONTAINER] ); SUMX ( ALL ( Table[Cliente] ); DISTINCTCOUNT ( Table[NO CONTAINER] ) ) )Regards,
MFelix
MFelix
Super User
Super UserHi Anonymous,
One thing I forgot, if you want to have a slicer/filter over the Cliente column instead of ALL use ALLSELECTED the rest of the syntax is the same.
ALL is gathering all the dataset and going over the filter selections.
Regards
MFelix
Thanks MFelix