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

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

    Hi Amit, got your point now.. in denominator there should not be filter, its entire count.. Great Thanks..!!

  • 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 ?