Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, here is my data structure
How do i create a generic fomula for Multiple in PowerBI to exclude A from it? (i.e., excluding A when applying the fomula in column E but keep C and D including A)
Thanks.
Solved! Go to Solution.
Hi,
Try these measures
Ratio = divide([cash inflow],[cash outflow])
Ratio final = calculate([Ratio],Data[Project]<>"Project A")
Hope this helps.
I need to exclude Project A from the total calculation.
Hi,
Try these measures
Ratio = divide([cash inflow],[cash outflow])
Ratio final = calculate([Ratio],Data[Project]<>"Project A")
Hope this helps.
Hi,
I am not clear about what you want. Assuming Cash inflow and Cash outflow are measure, write this measure
Measure = divide([Cash inflow],[cash outflow])
Hope this helps.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |