Forum Discussion

legored44's avatar
legored44
New Member
2 years ago
Solved

Get same row count from FACT in every row

Hello, I have the following formula, put in a table visual in Power BI:   CALCULATE(SUMX(_summarizedfact, DISTINCTCOUNTNOBLANK(DIM1[Project])), ALLSELECTED(DIM1))   Where _summarizedfact is jus...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi legored44 ，
    Here some steps that I want to share, you can check them if they suitable for your requirement.
    Here is my test data:
    Fact


    DIM1


    DATA MODEL

    Create measure

    ProjectCountTable = 
CALCULATE(
    SUMX(
        FILTER(
            'Fact',
            NOT ISBLANK('Fact'[Project])
        ),
        1
    ),
    ALLSELECTED(DIM1)
)

    Final output

     

     

    Best regards,

    Albert He

     

    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 legored44 ，
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Fact


DIM1


DATA MODEL

Create measure

ProjectCountTable = 
CALCULATE(
    SUMX(
        FILTER(
            'Fact',
            NOT ISBLANK('Fact'[Project])
        ),
        1
    ),
    ALLSELECTED(DIM1)
)

Final output

 

 

Best regards,

Albert He

 

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