Forum Discussion

HishamAT's avatar
HishamAT
Helper II
3 years ago
Solved

Display selected information

I have a table and i want to display the count for the passengers by : selected date and  1. By Traffic = ALL give me 10000 2. By Traffic = INS give me 8000 3. By Traffic = OUT give me 2000   ...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Anand24's avatar
    Anand24
    3 years ago

    Hi HishamAT ,
    Try below calculated measures:

    ALL Traffic Count = CALCULATE(COUNT(Table[Passenger]), Table[Traffic] = "All")

    INS Traffic Count = CALCULATE(COUNT(Table[Passenger]), Table[Traffic] = "INS")

    OUT Traffic Count = CALCULATE(COUNT(Table[Passenger]), Table[Traffic] = "OUT")

     

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
Anand24's avatar
Anand24
Super User
3 years ago

Hi HishamAT ,
Try below calculated measures:

ALL Traffic Count = CALCULATE(COUNT(Table[Passenger]), Table[Traffic] = "All")

INS Traffic Count = CALCULATE(COUNT(Table[Passenger]), Table[Traffic] = "INS")

OUT Traffic Count = CALCULATE(COUNT(Table[Passenger]), Table[Traffic] = "OUT")

 

 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn
  • HishamAT's avatar
    HishamAT
    Helper II
    3 years ago

    I changed them to : 

    ALL Traffic Count = CALCULATE(SUM(Table[Passenger]), Table[Traffic] = "All")

    INS Traffic Count = CALCULATE(SUM(Table[Passenger]), Table[Traffic] = "INS")

    OUT Traffic Count = CALCULATE(SUM(Table[Passenger]), Table[Traffic] = "OUT")