Forum Discussion

snow87's avatar
snow87
Icon for Helper I rankHelper I
4 years ago
Solved

How do you combine ALLEXCEPT and IF statements?

Could someone give me an example of combining allexcept and if?
Need Help
  • snow87's avatar
    snow87
    4 years ago

    Figured out a cludgy way of doing it with multiple columns. Thanks for looking into it.

PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

With some understanding of your requirement, I suppose this will work:

FIRSTNONBLANK(TOPN(1,VALUES(Growth[Bus]),[YourMeasure/Calculatedcolumn]),1)
snow87's avatar
snow87
Icon for Helper I rankHelper I
4 years ago

This gives me the same bus for all the stones. How do return the result for each stone id?