Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

I believe that you probably need to look at using a measure here where you do the SUMMARIZE in a VAR to create a temp table. Tough to say because I'm not sure what kind of visualization you are going for. I'll see if I can look at this a little closer to decipher what you are going for or is it as simple as you want a table visualization of the last table you presented?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Greg_Deckler

 

I am just looking for a simple table which will show two columns and data will change when I apply some filters. 

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Anonymous

     

    Try this technique

     

    First create a single column calculated table

     

    Parameters =
DATATABLE (
    "No of ID2 enabled", INTEGER,
    {
        { 1 },
        { 2 },
        { 3 },
        { 4 },
        { 5 }
    }
)

    Now you can write a MEASURE (Assuming TableName is Table1)

     

    Count of ID 1 =
VAR temp =
    SUMMARIZE (
        Table1,
        Table1[ID1],
        "Count of ID2", CALCULATE ( COUNT ( Table1[ID2] ), Table1[State] = "Enabled" )
    )
RETURN
    COUNTX (
        FILTER (
            temp,
            [Count of ID2] = SELECTEDVALUE ( Parameters[No of ID2 enabled] )
        ),
        [ID1]
    )

     

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Zubair_Muhammad

         

        You have created a table called parameters with values inserted in it manually. But the whole chanllenge with my problem i sto get those numbers populated automatically. I cannot add static column.