Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi there,
I am trying to calculate the percentage of events that occurred at a location. I want to calculate the percentage in such a way that if I select the year from the slicer then it gives me the percentage of events that occurred in the selected year. If nothing is selected then it gives a percentage of all years.
I am calculating measure something like that:
Solved! Go to Solution.
# Events = DISTINCTCOUNT( 'Main Table'[OutageID] )
Pct =
DIVIDE(
[# Events],
CALCULATE( [# Events], ALLEXCEPT( 'Main Table', 'Date'[RY] ) )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
# Events = DISTINCTCOUNT( 'Main Table'[OutageID] )
Pct =
DIVIDE(
[# Events],
CALCULATE( [# Events], ALLEXCEPT( 'Main Table', 'Date'[RY] ) )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
User | Count |
---|---|
84 | |
77 | |
76 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
45 | |
43 |