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])))

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

Hi,

Share the link from where i can download your PBI file.