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

 

TrafficPassenger
All10000
INS8000
OUT2000
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

2 Replies

  • 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")