Forum Discussion
Countrows giving improper aggregation
Hi Anonymous ,
According to your description, here are my steps you can follow as a solution.
(1)You can create a masure.
Measure = SUMX( 'filter_date' , [Deliveries at Normal Level all days attempt_v1])(2)Then the result is as follows.
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.
Hi Anonymous ,
I looked at your dax formula, for your table structure and I am not very clear.
For your question, 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.
When I select two companies, company A & company B my Dax does not throw correct output. For example, The normal column is a threshold column and if my orders are less than normal then it should be 2 (since two companies are selected). Therefore, the sum total of column should be 58 instead of 60 (1 april month X 2 companies = total 60 days).
My dax works when only 1 company is selected and it correctly shows if orders are less than threshold then 1.
My desired output is something like this: In the following months how many days were deliveries at normal level which is filterable btw companies as shown in the dummy power Bi file.
Here is my power Bi link -> Power BI Link
Hi Anonymous ,
According to your description, here are my steps you can follow as a solution.
(1)You can create a masure.
Measure = SUMX( 'filter_date' , [Deliveries at Normal Level all days attempt_v1])(2)Then the result is as follows.
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.
This is exactly what I was looking for. Thank you! 🙂