Forum Discussion
matrix
Hello, I am creating a Matrix / Pivot Table on Power BI. My 2 values per column id are both Distinct Counts. Is there a way I can combine the columns, so that IF the PROD1 column is empty and...
Hello, Thank you for the suggestion!
Unfortunately, Yes, I have tried that and several variations. I have also tried attaching Count() and DistinctCount() for the measures.
Is it possible to create a formula that accounts for matrix Values, not just the columns and rows?
Perhaps a FOR loop for each Value that appears in the matrix?
Hi edatero,
Maybe you could ceate measures to get the distinct count of PROD1 and ASSOC1. Then, create a third measure to combine their values like:
Measure=IF([MeasurePROD1]=BLANK() & [MeasureASSOC1]<>BLANK(), 0, [MeasurePROD1])
For more advice, please show us your desired output. Based on current description, I was confused about what you were trying to achieve.
Regards,
Yuliana Gu