Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
2 years ago
Solved

KPIs visuals Running incredibly slowly

Desktop and Service I have a star schema. The model has 9 tables and is 108.61 MB in size.   I have created DAX For DISTINCTCOUNT and then DAX for SAMEPERIODLASTYEAR to add as the goal value.   ...
Need Help
  • Syk's avatar
    Syk
    2 years ago

    You can try to use other functions to mimic the distinct count. Instead of counting from the fact table, we can use it to filter. Try this

    Distinct Persons=
CALCULATE (
    SUMX (
        VALUES ( Dimension_Table[PersonID] ), 
        1
    ),
    Fact_Table
)




DebbieE's avatar
DebbieE
Community Champion
2 years ago

I have my Person ID in the fact table. Not the Dimension though.  So I could do the DISTINCT Count

Syk's avatar
Syk
Resident Rockstar
2 years ago

Do you have a person dimension or is all your person detail stored in the fact table? That could also be affecting your performance

  • DebbieE's avatar
    DebbieE
    Community Champion
    2 years ago

    oh no. I have a person Dimension. I just added the ID to the fact table to make it easier to create the DISTINCTCOUNT against.

    • Syk's avatar
      Syk
      Resident Rockstar
      2 years ago

      Okay, so you can use the DAX I posted to count the IDs in the People table but use the fact table to make sure you're getting the proper filtering. I hope that makes sense?

      • DebbieE's avatar
        DebbieE
        Community Champion
        2 years ago

        What Ill do is switch the Person ID back into the DIM table and try the DAX you added and check against the original . I dont like the idea I came up with. Its too prone to errors.........