Forum Discussion
Blank Formula Help
Hi. I am trying to categorise numerial responses into 3 different categories. If they answered between 0-1 - I want to categorise that as 0-1 Day Active If they answered between 2-4 - I want...
Hi Anonymous ,
You could use ISFILTER() function.
Column = IF(ISBLANK('Table'[Answer]),BLANK(),IF('Table'[Answer]<1,"0-1 Active",IF('Table'[Answer]>=2&&'Table'[Answer]<=4,"2-4 Active","5+ Active")))Best Regards,
Jay
amitchandak
Super User
Super UserAnonymous , if answer is a column it should work
Switch ( True() ,
'Table'[Answer] <=1, "0-1 Active",
'Table'[Answer] <=4, "2-4 Active"
, "5+ Active")
But if it is a measure try for segmentation
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Hi there.
That DAX still categorisies when a cell under the Answer Column is blank as 0-1 Active.