- 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
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
04-28-2025 08:33 AM | |||
10-27-2017 02:56 PM | |||
04-09-2025 02:25 AM | |||
12-13-2024 03:17 PM | |||
02-21-2018 11:52 AM |
User | Count |
---|---|
71 | |
69 | |
38 | |
26 | |
26 |
User | Count |
---|---|
97 | |
96 | |
59 | |
44 | |
40 |