- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Calculating What-If Using Category as Number
Hello everyone!
I am currently running into a bit of a two-pronged problem with some What-If calculations. I have a snapshot of my intended outcome below:
What I am trying to calculate is the amount of visits for each new visit type (columns H,J,L,N,P,R). I have the steps outlined, and what they should perform in H5 through H7.
The second problem i am having is, how do I create this in one neat matrix? I am a bit lost on where to begin with this. I do have a What-If standalone table that looks like this:
Visit Type | Number |
Type A | 100 |
Type A | 50 |
Type A | 25 |
Type B | 80 |
Type B | 60 |
Type B | 40 |
And is connected to the main visit table with a Many:Many both ways based on Visit Type.
Any help is greatly appreciated!
Proud to be a Super User! | |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Your intended outcome is not achievable with Power BI. Either keep using Excel or modify your requirements.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Your intended outcome is not achievable with Power BI. Either keep using Excel or modify your requirements.

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
62 | |
46 | |
45 |