Forum Discussion

JAVED's avatar
JAVED
Icon for Helper I rankHelper I
8 years ago
Solved

Display multiple columns value with reference to 2 columns

Hi! I have a columnA and columnB with different numbers like 1,2,3,4,5 and 6,7,8,9,10. i have other coumns like R,4,W,D Now i have to display other columns like "If(a=1 and b=4 then sum(R),count(B),C...
Content Packs
Custom Visuals
Dashboards
Data Modeling
Gateways
Mobile
Report Server
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi JAVED,

     

    You can create a calculated column below: 

     

    Column = IF('Table1'[Column A]=1 && 'Table1'[Column B]=4,SUM('Table1'[Column R])&","&COUNT(Table1[Column B])&","&COUNT('Table1'[Column W])&","&COUNT('Table1'[Column D]))

     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi JAVED,

 

You can create a calculated column below: 

 

Column = IF('Table1'[Column A]=1 && 'Table1'[Column B]=4,SUM('Table1'[Column R])&","&COUNT(Table1[Column B])&","&COUNT('Table1'[Column W])&","&COUNT('Table1'[Column D]))

 

 

Best Regards,
Qiuyun Yu 

JAVED's avatar
JAVED
Icon for Helper I rankHelper I
8 years ago
This is not the exact output but i got it in a different way