Forum Discussion

Glibberg's avatar
Glibberg
Regular Visitor
3 years ago
Solved

Column on a Dashboard that extracts certain values from data

Hi  I have two columns: Column1 (integers) and Column2 (dummy variable - 0 or 1). I have to insert Column3 in my dashboard such that it shows only values in Column1 for which Column2 = 1.  What is...
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Glibberg 

     

    You can try the following methods.
    Table:

    Table 2 = SUMMARIZE(FILTER('Table',[Column2]=1),'Table'[Column1])

    The newly created table is your desired output and can be put directly into the dashboard.

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Glibberg 

 

You can try the following methods.
Table:

Table 2 = SUMMARIZE(FILTER('Table',[Column2]=1),'Table'[Column1])

The newly created table is your desired output and can be put directly into the dashboard.

 

Best Regards,

Community Support Team _Charlotte

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