Dividing count of related table values with normal table

[Anonymous]

Hi All, 

                                         Fig1.         

                                                                           

                         Fig2.

I am having trouble dividing related tables values as shown in Fig1 with a completery different table values  as shown in Fig2. It would be helpful if you could please provide some solutions. Also, can you divide coumns without having measures. 

Looking forward to hearing from you!

[JarroVGIT]

Hi @Anonymous ,

I am having a very hard time trying to understand what you are trying to achieve. It seems to me these are two tables with columns in different order but with the same data (although one is a subset of the other). What value are you trying to achieve? 

Perhaps have a look at this post, that might help in explaining your desired outcome better:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/bc-p/885093

Looking forward to hearing some more about your problem,

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous]

Hi @JarroVGIT ,

Thank you for your response. What I am trying to do is dividing count 2 with count 8 as shown in tables. The problem is that count 2 table contains values that are related to another table. So basically, it's a match of two tables. 

The count 8 table is from another table. 

The data looks the same but it's kind of different has been pulled from different sources.

Thank you! 

[JarroVGIT · Accepted solution]

Alright that clarifies a bit more but an overview of your datamodel would have been best. It sounds like you are looking for a measure like this:

Measure =
VAR sumTable1 = CALCULATE(SUM(Table1[Count of WO]), FILTER(Table1, Table1[column1] = <filtervalue>))
VAR sumTable2 = CALCULATE(SUM(Table2[Count of WO]), FILTER(Table2, Table2[column2] = <filtervalue>))
RETURN
DIVIDE(sumTable1, sumTable2)

WIthout knowing the structure of your data, nor your table names, nor your column names (or current measures), this is as specific I can be. Basically, in VAR sumTable1, I am trying to reproduce the '2' in your figures, and by VAR sumTable2 I am trying to reproduce the '8' in your figures. Then I return the DIVIDE() statement, dividing the two. 

Let me know if this helps!

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous]

@JarroVGIT  Thank you for your help. Probabaly I am not doing something right. Thank you for your time.