Forum Discussion

Back2Basics's avatar
Back2Basics
Icon for Resolver I rankResolver I
5 years ago

Calculate countif based on another table

Hi   I have an excel table with a column for 'outcomes'. Users are able to add several outcomes, separated by commas.  I have created a table in PBI which is just the possible 'outcomes' from the ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

In the Query Editor, you should split the outcome by rows to allow each outcome to appear in its own cell.  Now create your desired visual.  You may need to write a DISTINCTCOUNT() measure.