Hey,
I wonder if anyone can help. I wish to create a table like the below
| Venue Type | Booking fee | tickets sales | Total |
| Arena | 10 | 500 | 510 |
| Pub | 2 | 100 | 102 |
Where VenueType and ticketsales are specified within the data
Booking fee is a parameter and Total = Bookingfee + Ticket sales
The booking fee is negotiated so the user needs to be able to enter different values here. Also there are two different levels for booking fee dependant on the Venue type. The user needs to be able to enter different amounts for both and see the Total measure.
The venue types need to presented in the same table and the user should be able to view at the granularity displayed above.
I can get this working using 1 parameter with the Powerbi Parameter function but I can't scale to two. Does anyone have any ideas?
