Forum Discussion
Using a table visual, splitting the results into 2 columns
lc_finance I added the quick measure, but the report names I have are all valued at 2 now. When changing the filter to 'is 1' nothing appears, but 'is 2' produces all the reports.
Below is how I adapted your example to my data, if that helps.
Column number2 =
VAR numberOfRows = COUNTROWS('master')
VAR currentIndex = SELECTEDVALUE('master'[Index.1])
RETURN IF (currentIndex<=numberOfRows/2 , 1,2)
Hi Anonymous ,
could you share an example of your Power BI file?
That would help me to better understand the issue. You can upload it to a service like One Drive, Google Drive, Dropbox and then share the link.
Regards,
LC
lc_finance I am not able to due to the sensativity of the data. However, I think what I need is a calculated measure.
To recap, I have two slicers that filtered down a list of report names into a matrix. A second matrix is being added, and the filtered report names need to be split so that one half is in matrix one, and one half in matrix two. I don't think the correct solution is to split the underlying data but instead to have the result of the two slicers split. Would you agree?
Hi Anonymous ,
Yes, I agree, we should split the result of the slicers into 2.
Calculated measures are the right way to do it because they take into account the result of all the slicers.
I understand about the confidential data. In that case, could you share a sample Power BI file where you put sample/fake data?
A Power BI example would be very helpful in understanding why the measures I proposed to you do not seem to work
LC
Interested in Power BI and DAX tutorials? Check out my blog at www.finance-bi.com