Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
670 views
in Power BI by 2 3 5
closed by

I made everything that you answered in my last question DAX OPERATIONS BASED ON SLICERS POWER BI and your advice works perfectly:

Now, I want to do another operation with these results.

My second table "RELLENOS" has another column called "qrellmes" 

Cequip

qrellmes Nombre del mes
004315 60 Enero
004315 6 Diciembre
004315 4 Noviembre
004307 10 Enero
004307 8 Diciembre

There are more values in cequip and each one has a different value of "qrell" in different months.

What I want to do is a graphic with "qrell x cequip" and this next operation:

GAL_MEASURE = CALCULATE(SUM(RELLENOS[qrellmes]))/[HOROMETROX_MEASURE]

It shows me this graphic:

Power BI is dividing qrell / total (66 / 356344) not for each cequip. How I can solve that if the result should be 66/371 = 0.177, for example.

Thanks a lot for your previous answer.

closed with the note: I made a mistake creating a relation between my two tables. On the other hand, the previous advice made me realize how  the relations work. Thanks a lot sir!.
by 3 7 14
0 0
Great, you have found a solution for your problem, so please to be helpful for you and the future visitors, open your question again and add your detailed answer with image.
 In debug.to, we are focusing on the knowledge sharing with high quality content to be helpful for all! Thank you for understanding ♥

If you don’t ask, the answer is always NO!
...