Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Please help me

Can you please help me writing this same in power bi means the working should be same , Please help me as soon as you can its urgent 

 

 

  • Anonymous , Try like

    calculate(Minx(table, If(isblank(Table[Count]), Table[Function Group], "")), Allexcept(Table, Table[FolderID]))

     

    In allexpect use the fact table, even if the column is from dimension

     

    example

    Allexcept(Sales, Item[Brand])

     

2 Replies

  • Anonymous , Try like

    calculate(Minx(table, If(isblank(Table[Count]), Table[Function Group], "")), Allexcept(Table, Table[FolderID]))

     

    In allexpect use the fact table, even if the column is from dimension

     

    example

    Allexcept(Sales, Item[Brand])

     

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support

    Hi, Anonymous 

     

    Have you take amitchandak  's advice? If your problem has been solved, you can mark the answer as solution to close the thread. If not, Please let me know what's wrong with your desired result.

     

    Best Regards,
    Community Support Team _ Janey