Forum Discussion
Ignore grouping if value is found
I want to write a DAX which count the rows based on the grouping columns 'id' and 'date', but at the same time want to ignore the grouping count if the value contains x. below is the expected re...
v-lili6-msft
Community Support
Community Supporthi, joepath
For the different conditional filter, the summary table will get different result.
You could use the same way as I provided to add a new table to check the logic.
Hope it could help you.
Best Regards,
Lin
joepath
Helper II
Helper IIv-lili6-msft Or can we write a logic something like, create a flag in the review table and based on the grouping (activity date,user key,and org encounter key) if in the group any value found with Initial review then update all the additional review row flag with 0 and if we don't find any value in the group then update the flag with 1, and in the calculation we can use that flag to count the additional review. that will not be affected by the filter condition.
In Dax what are the function we can use to archive this?