Forum Discussion

cbarker's avatar
cbarker
Frequent Visitor
2 years ago

Matrix Including Values Which Are Not Relevant due to Date Calculation - How to Exclude?

I have a matrix table that ultimately is including values that have no data / relevant detail for the measures which are present in my values section. E.g. All customers are showing under every singl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi cbarker ,

 

You can create a calculated column.

 

YTD Work Days Compl =
COUNTROWS (
    FILTER (
        DimDate,
        DimDate[Date]
            <= TODAY () - 1
            && DimDate[Year] = "2024"
            && DimDate[Work Day] = 1
    )
)

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

 

Best Regards,

Neeko Tang

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