Forum Discussion
Calculating overlap between calculated columns
Hello lovely people, Given this table [Account] with calculated columns [SPx]. Account Account SP1 SP2 SP3 AAA 1 1 BBB 1 1 CCC 1 I have created a slicer c...
Hi qmartiny ，
Could you please provide some raw data from the Account table (before creating the calculated columns SP1,SP2 and SP3)? Could you please also provide the calculation logic for these calculated columns SP1, SP2 and SP3?Later I would like to see if these columns can be created in Power Query, if so, maybe we can also use the UNPIVOT function to achieve the final result you want. Even if not, we can find out if there is an alternative way to achieve what you want...
In addition, please check out the following links using different methods(DAX and Power Query). Hope that they can help you solve the problem...
DAX:
Calculating overlap between selected groups
Power Query:
Power BI: Percent Overlap Between Groups
Best Regards