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 |
---|---|
84 | |
79 | |
62 | |
62 | |
51 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |