Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count from Fact table and Week view

Trying to present in a visual the following information.    My Fact has below data  Doc ID Staus ID Status Desc Site Date Customer 1000 1 In Quote A 1/1/2021 2000 1020 2 In Re...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    1&2.You can try to create the following measure instead of the calculated table.

    Measure = 
CALCULATE(
    COUNT(Trans[Doc ID]),
    ALLEXCEPT(Trans,Trans[Site],Trans[Status Desc]
))

    3. Based on your description, I'm not sure how you want to limit the number of weeks.

    You can create a measure and put it into visual level filter.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi Anonymous ,

 

1&2.You can try to create the following measure instead of the calculated table.

Measure = 
CALCULATE(
    COUNT(Trans[Doc ID]),
    ALLEXCEPT(Trans,Trans[Site],Trans[Status Desc]
))

3. Based on your description, I'm not sure how you want to limit the number of weeks.

You can create a measure and put it into visual level filter.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.