Forum Discussion

PKGR's avatar
PKGR
Frequent Visitor
5 years ago
Solved

Data Type is not appearing for Measures.

Power BI Desktop not showing "Data Type" option, though it shows format option. Please help!  
Need Help
Tips and Tricks
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi PKGR ,

     

    >>thanks for your response, dropdown shows only "text" option after I wrote few calculation groups using tabular editor. 

     

    Calculation group is the root cause. Implicit column aggregations in Power BI are not supported for models with calculation groups. Currently, if DiscourageImplicitMeasures property is set to false (default), aggregation options appear, however they cannot be applied. If DiscourageImplicitMeasures is set to true, aggregation options do not appear.

     

    You can refer to the post: https://community.powerbi.com/t5/Desktop/Tabular-Editor-Calculation-groups/m-p/1283596

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

PKGR's avatar
PKGR
Frequent Visitor
5 years ago

negi007 thanks for your response, dropdown shows only "text" option after I wrote few calculation groups using tabular editor. 

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    5 years ago

    PKGR I am not sure why it is happening to your measure. I have tried similar things at my end and facing no issue. Can you try using INT function like int(5/6) and see if you get other option. Normally text format only comes when value in the measure is in the text format and cannot be converted to integer/number