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
shebr's avatar
shebr
Resolver III
8 years ago

Hi edatero

 

Have you tried creating a column with the formula ="IF(IsBlank(PROD1) & NOT(ISBLANK(ASSOC1), 0, PROD1)"?

 

shebr

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

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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