Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Block relational filter

Hello everyone,   How can I use the calculation of a measure without considering the filter of the relationship column between tables?   I have these two tables, Table Employee and Table Calendar...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    Use the all formula on the calculation:

     

     

     

    Business day by Employee = COUNTROWS(FILTER(ALLSELECTED('Table Calendar'); 'Table Calendar'[Business day] = 1))

     

     

    Not on computer did this by heart may need some changes.

     

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

Anonymous , if business day value is 1 and 0

the sum will give what you have in actual and the count will give what you have desired output