Forum Discussion

powerbilover123's avatar
powerbilover123
Regular Visitor
2 years ago
Solved

Getting value from another table (timeperiod)

I have a measure that takes every unique timeperiod value from a dimension-table and then calculates what value falls in that timeperiod in the fact-table and counts them. I want to create a g...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi powerbilover123 

     

    For your question, here is the method I provided:

     

    Here's some dummy data

     

    "dim"

     

    "fact"

     

    Create a measure. Counts the values in the fact table for that time period.

     

    count num = 
var _dimtime = SELECTEDVALUE('dim'[Time])
var _facttime = SELECTEDVALUE('fact'[Time])
RETURN
IF(
    _dimtime = _facttime, 
    CALCULATE(COUNTROWS('fact'), FILTER('fact', 'fact'[Time] = MAX('fact'[Time]))), 
    0
)

     

    Here is the result.

     

     

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi powerbilover123 

 

For your question, here is the method I provided:

 

Here's some dummy data

 

"dim"

 

"fact"

 

Create a measure. Counts the values in the fact table for that time period.

 

count num = 
var _dimtime = SELECTEDVALUE('dim'[Time])
var _facttime = SELECTEDVALUE('fact'[Time])
RETURN
IF(
    _dimtime = _facttime, 
    CALCULATE(COUNTROWS('fact'), FILTER('fact', 'fact'[Time] = MAX('fact'[Time]))), 
    0
)

 

Here is the result.

 

 

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.