Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Icon for Helper V rankHelper V
3 years ago
Solved

cannot 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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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

niranjanm45's avatar
niranjanm45
Frequent Visitor
2 years ago

Hi amitchandak ,

 

I am trying to calculate values in % such as every X-axis value is considered 100%, hence using filter in my DAX, but getting the error for cannot convert text type to true/false. I am using following DAX:

 

%Emotion = DIVIDE(CALCULATE(DISTINCTCOUNT('SportRec QB5'[uuid]), FILTER('SportRec QB5','SportRec QB5'[Emotion])),CALCULATE(DISTINCTCOUNT('SportRec QB5'[uuid]),ALL()))
 
Can you help me ?