Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I need help importing a table that has emdebed rows with summary information, see the example bellow:
As you can see the first appearence of the observation in column group is the summary of the subsequent observations within the same gruop. However not all the the observations have subgroups in (see the last row), in that case I would like to have that row included, which means I can not solely filter by subgroup.
Any idea on how to import this to power Bi?
Thanks
Solved! Go to Solution.
@kjerez , Create a new column like
new column =
var _Sub = countx(filter(Table,[group] =earlier([group]) && not(isblank([sub group]))),[sub group])+0
if(_sub >0, "Has sub group", "No Sub group")
Thanks,
I ended up using:
Column = var _Sub = COUNTX(FILTER('All Types',[Group Name]=EARLIER([Group Name]) && NOT(ISBLANK([SubGroup]))),[SubGroup])+0 return if(_sub >0, "Has sub group", "No Sub group")
I also create another dummy variable with subgroup, and created a filter combining these two.
@kjerez , Create a new column like
new column =
var _Sub = countx(filter(Table,[group] =earlier([group]) && not(isblank([sub group]))),[sub group])+0
if(_sub >0, "Has sub group", "No Sub group")
Thanks,
I ended up using:
Column = var _Sub = COUNTX(FILTER('All Types',[Group Name]=EARLIER([Group Name]) && NOT(ISBLANK([SubGroup]))),[SubGroup])+0 return if(_sub >0, "Has sub group", "No Sub group")
I also create another dummy variable with subgroup, and created a filter combining these two.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |