Forum Discussion

Changlin's avatar
Changlin
Frequent Visitor
4 years ago
Solved

Merged Table data not displaying data correctly in chart

Hi,   I have merged 2 tables A and B with left join in Power BI. Table A has 355 rows (Contains ID, Name columns) and Table B (Contains ID, State and Created Date columns) has thousands rows. I got...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Changlin ,

     

    Please try:

    Count = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),[State]=MAX('Table'[State]) && [Date]<=MAX('Table'[Date])))

    Output:

    Best Regards,
    Eyelyn Qin
    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
4 years ago

Hi Changlin ,

 

Please try:

Count = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),[State]=MAX('Table'[State]) && [Date]<=MAX('Table'[Date])))

Output:

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

Changlin's avatar
Changlin
Frequent Visitor
4 years ago

Hi Eyelyn,

 

Thanks for your answer, your query helps me solve the problem. I have marked you answer as solution.

 

Have a good day,

 

Changlin