Forum Discussion

edatero's avatar
edatero
Frequent Visitor
8 years ago

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...
Need Help
edatero's avatar
edatero
Frequent Visitor
8 years ago

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?

shebr's avatar
shebr
Resolver III
8 years ago

Hi edatero

 

I dont believe so no, but im also struggling to understand exactly what it is you are trying to achieve. It sounds like its possible but its not the solution you want. Can you perhaps go through this again step by step? Or perhaps provide the pbix file or analysis?

 

Thanks

 

shebr