Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |