Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 3 different tables that are connected by date: Budget, Plan and Actual. They all have same inidicators: Number of chickens and total weight.
Currently, I have such table:
Name | Budget | plan | actual |
number of chicken, unit | 2 | 3 | 4 |
number of chicken, kg | 1 | 2 | 3 |
and I want to calculate average weight and visualise it with other two indicators. the formula is average weight = number of chicken, kg / number of chicken, unit.
I want such table:
Name | Budget | plan | actual |
number of chicken, unit | 2 | 3 | 4 |
number of chicken, kg | 1 | 2 | 3 |
average weight chicken | 0,500 | 0,667 | 0,750 |
How can I accomplish that? I am limited with tables inside power bi
Solved! Go to Solution.
pls see the attachment below.
Proud to be a Super User!
Hi,
Assuming number of chicken, unit and number of chicken, kg are 2 measures that you have already written, write this additional measure
[average weight chicken]=divide([number of chicken, kg],[number of chicken, unit])
Hope this helps.
@Ashish_Mathur unfortunately they are not measures. they are are in columns values and indicators. Furthermore, budget, actual and plan are separate tables
Hi,
You may download my PBI file from here.
Hope this helps.
you can try with ISFILTER
budget2 = if(ISFILTERED('Table'[Name ]), sum('Table'[Budget]),CALCULATE(sum('Table'[Budget]),FILTER('Table','Table'[Name ]="number of chicken, kg"))/CALCULATE(sum('Table'[Budget]),FILTER('Table','Table'[Name ]="number of chicken, unit")))
ISFILTERED function (DAX) - DAX | Microsoft Docs
Proud to be a Super User!
SHould i have to create 3 different measures for each table? If I create 3 different measure, how do i visualize them in one table?
could you pls provide the sample data?
Proud to be a Super User!
I have calculate measure for each one and have following table
So I want to lets say transpose the table which should look like:
Name | Budget | plan | actual |
number of chicken, unit | 2 | 3 | 4 |
number of chicken, kg | 1 | 2 | 3 |
average weight chicken | 0,500 | 0,667 | 0,750 |
Actual
Date | Value | Indicator |
29.12.2021 | 41 493 | chicken, unit |
29.12.2021 | 40 343 | chicken, unit |
29.12.2021 | 40 044 | chicken, unit |
03.01.2022 | 36 744 | chicken, unit |
03.01.2022 | 35 912 | chicken, unit |
29.12.2021 | 93 079 | chicken, kg |
29.12.2021 | 85 267 | chicken, kg |
29.12.2021 | 83 878 | chicken, kg |
03.01.2022 | 90 838 | chicken, kg |
03.01.2022 | 85 395 | chicken, kg |
Budget
Date | Value | Indicator |
29.12.2021 | 50 000 | chicken, unit |
29.12.2021 | 60 000 | chicken, unit |
29.12.2021 | 50 000 | chicken, unit |
03.01.2022 | 40 000 | chicken, unit |
03.01.2022 | 30 000 | chicken, unit |
29.12.2021 | 93 079 | chicken, kg |
29.12.2021 | 85 267 | chicken, kg |
29.12.2021 | 83 878 | chicken, kg |
03.01.2022 | 90 838 | chicken, kg |
03.01.2022 | 85 395 | chicken, kg |
Plan
Date | Value | Indicator |
29.12.2021 | 50 000 | chicken, unit |
29.12.2021 | 60 000 | chicken, unit |
29.12.2021 | 50 000 | chicken, unit |
03.01.2022 | 40 000 | chicken, unit |
03.01.2022 | 30 000 | chicken, unit |
29.12.2021 | 93 079 | chicken, kg |
29.12.2021 | 85 267 | chicken, kg |
29.12.2021 | 83 878 | chicken, kg |
03.01.2022 | 90 838 | chicken, kg |
03.01.2022 | 85 395 | chicken, kg |
pls see the attachment below.
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |