Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, stumped by this one.
I have a table with the following structure:
Month_Start
Goal
Example values would be:
9/1/2019
150
I then have a gauge visual that performs the following:
Value = TOTALMTD([AppointmentCount], 'Appointments'[createDate])
Where [AppointmentCount] is simply defined as SUM(Appointments[Count]) + 0
This value works fine and displays as it should.
Next i want to show a tick of where the goal is, I created a measure on my Goals table as follows:
_created_goal = LOOKUPVALUE(Goals[goal_value],Goals[MonthStart],DATE(YEAR(TODAY()), MONTH(TODAY()), 1))
This works fine and displays as it should.
Last i need to add a filter onto the result to remove certain rows from the Appointments table, I add the column from Appointments into the filters pane, and set it to values I want to include "ind_origin = Y".
This suddenly breaks my _created_goal measure, and i get a result of (Blank)
I belive it is trying to filter the goals table on that column causing it to return nothing. I can't sort out how to remove any filter on that measure, or do i have to apply that filter directly to my measure on Appointments?
Hi @pe2950
Do you have a simple worksheet or preferable a dummy pbix?
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |