Forum Discussion
PowerBIBeginer
Helper V
Helper Vcannot convert value type text to type true/false - error is not resolving
Hi All, I've below dax. Suddenly I'm getting error of "cannot convert value type text to type true/false" and tried lot of methods but its not resolving. Can anyone please guide me here. Request ID ...
PowerBIBeginer , there is not filter condition here
FILTER(ALLEXCEPT('SRQ PP','SRQ PP'[Client Region],'SRQ PP'[Assoc Location],'SRQ PP'[Request Type - TAT]),'SRQ PP'[Final Closed Month])
what filter you want on month
amitchandak
Super User
Super UserPowerBIBeginer , there is not filter condition here
FILTER(ALLEXCEPT('SRQ PP','SRQ PP'[Client Region],'SRQ PP'[Assoc Location],'SRQ PP'[Request Type - TAT]),'SRQ PP'[Final Closed Month])
what filter you want on month
PowerBIBeginerHelper V
Helper VHi Amit, got your point now.. in denominator there should not be filter, its entire count.. Great Thanks..!!