Forum Discussion

APEREZ2's avatar
APEREZ2
Icon for Advocate I rankAdvocate I
4 years ago

Filter based on different columns depending on user selection

Good morning,   I want to create a report that detects everything affect a company like a IN OUT and show in a unique column. I try to do this with a measure like that: CALCULATE(count(Orders), ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

APEREZ2 , Ideally you should use an independent company table for filter.

 

or try like


CALCULATE(count(Orders), filter(Data,Data[Company Recipient]=SELECTEDVALUE(DimCompany[Company]) || Data[Company Sender]=SELECTEDVALUE(DimCompany[Company])) , crossfilter(DimCompany[Company],Data[Company Recipient], none ))

 

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE