Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
having the following columns :
The right column is a measure with the following code:
Solved! Go to Solution.
Its is due to the scope of the filters.
Try creating a new measure with this check = hasonefilter(somecolumn) and add it to your table to find out which column has filter and not on the total value.
Then you can wrap your measure for ticket price into if(hasonefilter(filteredcolumn);do something; dosomething else)
see this video as well explaining why this is happening:
https://www.youtube.com/watch?v=Ka7Ds4EAjNQ
Try the following using the values function.
In the values function you need to put the DIMENSION which is in the first column on the table.
It is not visible on your image
sumx( VALUES( 'Step6'[DIMENSION] ); CALCULATE(SUM( hour('Step6'[Times.Time])))) + do the same for the other 3 measures
Its is due to the scope of the filters.
Try creating a new measure with this check = hasonefilter(somecolumn) and add it to your table to find out which column has filter and not on the total value.
Then you can wrap your measure for ticket price into if(hasonefilter(filteredcolumn);do something; dosomething else)
see this video as well explaining why this is happening:
https://www.youtube.com/watch?v=Ka7Ds4EAjNQ
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |