Forum Discussion
Advocate IIValues in calculated column do not filter according to date selected - Need Help
Hi AmeenVanakar.,
Here is my solution.
Resident RockstarHi AmeenVanakar,
I did some changes on my first pbix file and I think now is working as you want. For example, on 04/05/2023 we have 3 rows without customer number so the old dax formula will count 3 visits but with the new one is counting only one visit.
Take a look at my new pbix file.
Advocate IIHi _AAndrade ,
The calculations work very well with the measures you've created 👍. However, we need to bring this all together in a column format along with bill range (bill value) so we can use it as a filter at the dashboard level, only then will we be able to run the analysis accurately.
Is there a way to use the measures as filters?
- _AAndrade
I didn't understand your point.
What is wrong on my pbix file? I have one filter with visits and have your first filter with bill classification.
What is not working properly?- AmeenVanakar
Can you help me with the bill range filter? the current filter doesn't filter the 'Total Sales Final' values within the specified range.
- _AAndrade
Hi AmeenVanakar.,
Here is my solution.