Forum Discussion

ALVIV99's avatar
ALVIV99
New Member
4 years ago
Solved

CANCEL SALES

Hey, I'm very new in Power Bi and I have an issue.   I need to create a measure of Cancel Sales, the problem is that I have only one column of Sales that in there includes the Sales and Cancel Sale...
Need Help
Show and Tell
Tips and Tricks
  • ALVIV99's avatar
    ALVIV99
    4 years ago

    I found the answer while searching the internet, I use USERELATIONSHIP

     

    1) I took my Column (FECHA_CANCELA) and connected with my Calendar Table(CALENDARIO[DATE]),we can see that when these two tables are connected, it will not be a primary connection but a secondary one, since a dotted line will be seen.

     

    2) Now I use this new Meassure

    CANCEL SALES = CALCULATE( [TOT SALES] , USERELATIONSHIP(CALENDARIO[Date],FACTURAS[FECHA_CANCELA]))
     
    Now I can see my CANCEL SALES
    All in a NEW MEASURE not in a column

     

ALVIV99's avatar
ALVIV99
New Member
4 years ago

I found the answer while searching the internet, I use USERELATIONSHIP

 

1) I took my Column (FECHA_CANCELA) and connected with my Calendar Table(CALENDARIO[DATE]),we can see that when these two tables are connected, it will not be a primary connection but a secondary one, since a dotted line will be seen.

 

2) Now I use this new Meassure

CANCEL SALES = CALCULATE( [TOT SALES] , USERELATIONSHIP(CALENDARIO[Date],FACTURAS[FECHA_CANCELA]))
 
Now I can see my CANCEL SALES
All in a NEW MEASURE not in a column

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ALVIV99 ,

 

Now that you have found a solution, please mark your own reply as the answer, and more people will benefit from it.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.