Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX mesaure / Need help

Hello, everyone,
I am creating a DAX measure to calculate a distinct count using (Distinctcount) the number for which the "START" intervention exists and for which at least one "END" intervention exists. You can see the columns below: The columns are from the same table called Table 1. according to this figure, there are a lot of data. 

 

Capture.PNG

My best regards. Thank you.

DAX filter formula
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi

    I made a solution, you see if my understanding is wrong. What I understand is to find the number of distinct values of column 1 that are common to start and end.

    Below is my table:

    I create a new table to find End and Start common row.

    The following DAX might work for you:

    Measure = 
    CALCULATE(
        DISTINCTCOUNT('Table'[Column1]),
        EXCEPT('Table','Table (2)')
    )

    The final output is shown in the following figure:

    Please feel free to let me know if I understand the wrong requirements.

    Best Regards,

    Xianda Tang

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

  • sjoerdvn's avatar
    sjoerdvn
    Icon for Solution Sage rankSolution Sage
    2 years ago

    try something like

    Example measure = COUNTROWS(INTERSECT(
	CALCULATETABLE(VALUES('Table 1'[Column 1]), 'Table 1'[Column 2]='Start')
	,CALCULATETABLE(VALUES('Table 1'[Column 1]), 'Table 1'[Column 2]='End')
))