Forum Discussion

ashuaswinireddy's avatar
ashuaswinireddy
Helper I
2 years ago
Solved

Substract Total count from specific event

Hello All,   I have below Data Number Category Event 123 UN MV1 124 UN MV2 128 IM MB1 129 IM MB2 137 FE MB1 189 IM MB2 190 UN SO 198 FE PO 200 IM ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

This could be the type of method you are looking for?

Total Number = COUNTROWS('Example')
Total Number - MB1 = var totalNumber = [Total Number]
var MB1 = CALCULATE(
    [Total Number],
    'Example'[Event] = "MB1"
)
RETURN
totalNumber - MB1
  • ashuaswinireddy's avatar
    ashuaswinireddy
    Helper I
    2 years ago

    Yes, I am looking this type of logic for multiple events to create burndown chart

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, ashuaswinireddy 

      Have you solved your problem? If so, mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!