Forum Discussion

sflynn's avatar
sflynn
Icon for Helper I rankHelper I
5 years ago
Solved

DAX Measure Category Total per row

I am trying to display the total count by category for each line item within the category based on the slicer selections. The problem I am having is if I use a count ignoring the field used in the sl...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    sflynn , Not very clear, Try a measure like

    Calculate(Countrows('Data'),filter(allselected('Data'),'Data'[Name] = max('Data'[Name]) && 'Data'[Month] =max('Data'[Month])))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

sflynn , Not very clear, Try a measure like

Calculate(Countrows('Data'),filter(allselected('Data'),'Data'[Name] = max('Data'[Name]) && 'Data'[Month] =max('Data'[Month])))

  • sflynn's avatar
    sflynn
    Icon for Helper I rankHelper I
    5 years ago

    That worked! Thank you for help, very much appreciated.