Forum Discussion

RichJW's avatar
RichJW
Icon for Helper III rankHelper III
4 years ago

Splitting tables on different tabs by %

Hi,   I’m using Power BI Desktop and I am having difficulty in splitting 2 tabs of data equally.   In summary… One tab has a table of data, which can have 30+ entries (rows) in the table. As the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi RichJW ,

 

Create a measure like below and add it to visual filter. Visual_1 set value = 1, Visual_2 set value = 0.

Measure = 
var _index = CALCULATE(COUNTROWS('Table'),'Table'[id]<=MAX('Table'[id]))
var _mid = ROUNDDOWN(COUNTROWS(ALLSELECTED('Table'[id]))/2,0)
return
IF(_index<=_mid,1,0)

 

Best Regards,

Jay

RichJW's avatar
RichJW
Icon for Helper III rankHelper III
4 years ago

Hi Anonymous ,

 

Thank you so much, that will help me immensly. I'll test it over the next few days and will accept as a solution if I can get it to work.

 

Cheers,

Rich