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...
What are you using to calculate ASSOC1?
Can you please post it so that I can work of of that
Yes! In the second table I posted, Dealers and Manufacturers are associated to each other by their arbitrary I.D. "key." If a key exists, it simply shows as "1" in the ASSOC1 column (The calculation is Distinct Count of these keys for each respective column-row).