Forum Discussion
ExcelMonke
Impactful Individual
Impactful IndividualDeveloping a model based on changes in a Dimension
Hi Fabric Forum, Looking for anyone that may have some good ideas on how to best create data models based on calculations and changes in a dimension. For some detail: I currently have a Location...
Read about how to handle SCD2 (slow changing dimensions)
Hi ExcelMonke ,
Can you show me you sample dataset?
It's easy to reach your Goal, and here's an example for you:
"Active" / "Inactive" =
VAR _COUNT =
CALCULATE(
DISTINCTCOUNT('Fact Table'[Date]),
ALLEXCEPT('Fact Table', 'Fact Table'[department])
)
RETURN
IF(
_COUNT >= 'Parameter'[Parameter Value],
"Active",
"Inactive"
)Use this DAX to create a measure or calculated column, and the final output is as below:
But as for the performance aspect, this needs to be judged specifically based on the amount of data you have and the complexity of the data structure.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ExcelMonkeHmm unfortunately that will not meet the needs of what I am trying to accomplish. The parameter value is not something that is user-selected. It is based off of a set of measure calculations