Forum Discussion

619SK's avatar
619SK
Helper II
2 years ago

Urgent Help !!!Report view for with condition - Weekly

My task is to add "point" column based upon sample data.  have added sample data along with condition. 1) How to calculate point based upon condition  and add in report view with weeks filter 2) Ho...
Need Help
619SK's avatar
619SK
Helper II
2 years ago

If i add Filter with Status (Open/Close) then it shows only Age category which is having values.

How can i show Age category  as 0  and Point 100.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi 619SK ,

Please try:

Points = 
VAR _cur_category = SELECTEDVALUE('Table'[Age Category])
VAR _count = [Open Defect Count]
VAR _points = CALCULATE(SUM('ConditionTable'[Value]),'ConditionTable'[Attribute]=_cur_category && 'ConditionTable'[Count of Defect]=_count) + 0
RETURN
_points

And

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group