Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Distinct/ Distinct count by key category

Hi everyone, I need your help😥   I would like to add red column to my table. Key of the group for distinction would be "show" and "FY".     shop item FY item count itme name ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , try like

    Measure = CALCULATE(COUNTX(VALUES('Item'[Item]),('Item'[Item])),ALLEXCEPT('Item','Item'[shop] , Item'[FY] ))

    Measure = CALCULATE(CONCATENATEX(VALUES('Table'[Item]),('Table'[Item])),ALLEXCEPT('Table','Item'[shop] , 'Item'[FY] ))

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , try like

Measure = CALCULATE(COUNTX(VALUES('Item'[Item]),('Item'[Item])),ALLEXCEPT('Item','Item'[shop] , Item'[FY] ))

Measure = CALCULATE(CONCATENATEX(VALUES('Table'[Item]),('Table'[Item])),ALLEXCEPT('Table','Item'[shop] , 'Item'[FY] ))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak 

that was perfect😂

Thank you so much😌