Forum Discussion

lancersc's avatar
lancersc
Helper I
1 year ago
Solved

DistinctCount and AllExcept

Hi! Below is the DAX forumula without date. I want the distinctcount without being affected by filters except for GL account type and Invoice line. Below is the counter, 67 is a distinctcou...
  • lancersc's avatar
    lancersc
    1 year ago

    Hello!

    I can't share the PBIX file because it containts the company data BUT I figured it out. I made a separate Date table and made a relationship between the Main Table and Date Table.

    Thanks anyways!