Forum Discussion
Problems with DAX Formula for measure
Hello everyone, I'm not much experienced with DAX and got stuck trying to perform one calculation. I'm using a funnel visual to display the ranking of tickets raised by user. What I want to do i...
amitchandak
Super User
Super Userangelompcunha , Date is already filtered in else just try to use count
Ranking by Day = IF(NOT(ISFILTERED('Date Table'[Date])),CALCULATE(COUNT('Data Table'[Incident ID]),'Date Table'[Date]=TODAY()),CALCULATE(COUNT('Data Table'[Incident ID])))
I still got the same behaviour when using that formula. The count of incidents does update correctly for each user but the actual user list does not change.
I have the feeling that I'll need to create a second measure to place it in the Group section of the funnel which would apply the same logic as the Ranking by Day but instead would return the list of users for the day selected but i'm not entirely sure if that is the way