DAX Fun

---

Pinky0404 wrote:

Hi,

 

Here is the sample data set .

 

 

 

---

Pinky0404

You need to union those 3 tables

Surveys = UNION(Survey1,Survey2,Survey3)

Then create measures as 

perc A & B & C = 
VAR summizedTbl =
    SUMMARIZE (
        FILTER ( Surveys, Surveys[Primary Clicked] = TRUE ),
        Surveys[Email address],
        "CNT", DISTINCTCOUNT ( Surveys[Survey Title] )
    )
RETURN
    DIVIDE (
        COUNTROWS ( FILTER ( summizedTbl, [CNT] = 3 ) ),
        DISTINCTCOUNT ( Surveys[Email address] )
    )



perc A & B = 
VAR summizedTbl =
    SUMMARIZE (
        FILTER ( Surveys, Surveys[Primary Clicked] = TRUE &&(Surveys[Survey Title]="Survey upgrade"||Surveys[Survey Title]="Survey Apple") ),
        Surveys[Email address],
        "CNT", DISTINCTCOUNT ( Surveys[Survey Title] )
    )
RETURN
    DIVIDE (
        COUNTROWS ( FILTER ( summizedTbl, [CNT] = 2 ) ),
        DISTINCTCOUNT ( Surveys[Email address] )
    )



perc A = 
    DIVIDE (
        COUNTROWS ( FILTER ( Surveys, Surveys[Primary Clicked] = TRUE &&(Surveys[Survey Title]="Survey upgrade" ) )),
        DISTINCTCOUNT ( Surveys[Email address] )
    )

See more details in the attached pbix file.