Forum Discussion
Anonymous
7 years agoNot applicable
Measure based on selected hierarchy
Hi, I have a question that is more related to the Tabular model and Excel connected to that model then Power BI but it's still viable in Power BI. My model is 3 tables: Date creation, Date resol...
Anonymous
7 years agoNot applicable
-- DAX rule number 1: NEVER filter a table
-- when you can filter a column.
-- measure 1 (internal, hidden)
[_IssuesCreated] = COUNTROWS ( Issue )
-- measure 2 (internal, hidden)
[_IssuesResolved] =
calculate(
[_IssuesCreated],
keepfilters ( not isblank( Issue[Resolution] ) )
)
-- measure 3
[Calendar Chosen] =
var __creation = isfiltered( 'Creation Dates' )
var __resolution = isfiltered( 'Resolution Dates' )
var __both = __creation && __resolution
return
switch( true(),
__both, "both",
__creation, "creation",
__resolution, "resolution",
"none"
)
-- measure 4
[Issues Resolved] =
var __calendarChosen = [Calendar Chosen]
var __value = [_IssuesResolved]
return
switch( true(),
__calendarChosen in {"both", "creation"}, blank(),
__calendarChosen in {"resolution", "none"}, __value,
blank() // just in case but should not happen
)
-- measure 5
[Issues Created] =
var __calendarChosen = [Calendar Chosen]
var __value = [_IssuesCreated]
return
switch( true(),
__calendarChosen in {"both", "creation"}, __value,
__calendarChosen in {"resolution", "none"}, blank(),
blank() // just in case but should not happen
)
Best
D.