Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Cannot reference a non numeric measure in DAX from another Power BI dataset

Hi team, I connected with company sever via getting data from "PBI datasets". But when I create new measures, I find that I can only reference numeric fileds from that dataset. Non-numeric fileds ca...
Power BI dataset
  • d_gosbell's avatar
    d_gosbell
    3 years ago

    It is not valid to reference a column in an IF function in a measure like that. This is why the PROD_STATUS_CODE is not showing. It has nothing to do with the data type. 

     

    If you did something like COUNTROWS( FILTER( Query1, Query1[PROD_STATUS_CODE] = "XXX" )) it should work. If you can explain a bit more about what you are trying to calculate we can probably explain how to achieve the result you are after.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

It is not valid to reference a column in an IF function in a measure like that. This is why the PROD_STATUS_CODE is not showing. It has nothing to do with the data type. 

 

If you did something like COUNTROWS( FILTER( Query1, Query1[PROD_STATUS_CODE] = "XXX" )) it should work. If you can explain a bit more about what you are trying to calculate we can probably explain how to achieve the result you are after.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for your help! I am trying implement something like "SUMIF" in excel. E.g. I would like to create a measure "OPEN sales" to calculate the total sales amount whose STATUS_CODE is "OPEN".